Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Need of an Excel Formula

  Asked By: Craig    Date: Sep 21    Category: MS Office    Views: 802
  

Can anyone help me figure out a formla that has a similar index match function,
but instead of picking the first selection of a repetitive item in the list,
itwouldsum the repetitive item in the total calculation. Please note
I'm not looking for a sumif formula, see example below.

Fig 1) source data
name units net rev
bear 1 1
10.00
bear 2 1
15.00
bear 1 2
20.00

Fig 2)
Report:
bear
1 bear 2
Unit
3 1
net rev 30.00 15.00

Fig 2 is the template that Ineedcreate a formula using one lookup
function that wouldmatchheadersacross the columns and
rowsdown the list.

Actually my data source is very large and it takes several sumifs and several
look up to pull in the report. Is there a one formula solution that can
accomodate all this pull?

I'll appreciate the help.

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Betty White     Answered On: Sep 21

Use a pivot table..............................

 
Answer #2    Answered By: Beverly Brooks     Answered On: Sep 21

if you are not looking for Sumif formula  then Use
array Function In Excel

 
Answer #3    Answered By: Adelfrid Fischer     Answered On: Sep 21

I'm not familiar with array functions. I did use the pivot table and it worked, but I guess if would me more effective in my case if
you show me how to write an array formula.

 
Didn't find what you were looking for? Find more on Need of an Excel Formula Or get search suggestion and latest updates.




Tagged: