summing mulitple lookup values revisited, catchy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello, i am not too bright, so this'll probably be obvious to most of you
I now need to add up 2 columns, and stick that in the total, i.
Fruit No. in Europe no. in America Total in europe and americ
Apples 1 2
Apples 2
Bananas 3 3 2
Bananas 3
Bananas 4

any ideas
ps. these numbers are just made up, don't rush out and buy the last bananas.
 
Hi
you should stay in the same thread. Makes it easier to understand your
problem :-)
Try the following formula
=IF($A2<>$A1,SUMPRODUCT(--($A2:$A$999=$A2),($B2:$B$999)+($C2:$C$999)),"
")
and copy down

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summing mulitple lookup values, catchy 4
Calculated Item in a Pivot Table 2
How do I lookup only Apple and return value on Price Column and su 2
Sum values referring to a cell with same value 3
count of totals for pivot table 3
Single-cell array calculation bug in Excel? 3
Sum of different value in different worksheet & cell number 2
Countif a corresponding value is not equal to zero or blank 1

Back
Top