Index to return a sum of corresponding matching rows

[alex1alex]

Fruit	Number	Sum
Apple	10	=16
Apple	6	=16
Pear	1	=1

<tbody>
</tbody>

Hello,

Im trying to do an index formula that will give me the SUM column.
Look up the fruit on this row, then add up all the corresponding numbers for that fruit.

I keep looking at index examples...from the description it sounds like that's possible but I'm not getting anywhere.

Is this possible? How would you do that?

Many Thanks,
Alex

 

[Special-K99]

=SUMIF(B1:B3,"Apple",A1:A3)

INDEX returns an individual cell.

in D1 put Apple
in D2 put Pear

in E1
=SUMIF($B1:$B3,D1,$A1:$A3)
copy down to D2

 

[alex1alex]

This is my embarrassed face.


Thanks Special-K.

(As an aside, in the end I can just use A1 instead of the D1 since I want % of Apples/Bananas. IE, =B1/Sumif($B1:$B3,A1,$A1:$A3). I guess I should have column B Number of Sub-Type instead of just number.)

 

[alex1alex]

just noticed the SUMIF formula's above have switched the RANGE and Sum_range fields ....... it's supposed to be SUMIF(range, criteria, [sum_range])....

SO, for that last example....it's:

=B1/Sumif($A1:$A3, A1, $B1:$B3)


(just in case someone runs across this...don't want them to be confused