summing mulitple lookup values revisited, catchy

[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.

 

[Frank Kabel]

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