Summing distinct rows in same cell

[summergs]

Sorry for the bad title I'm not sure hte best way to sum up this issue.

Fruit Price Total
Apples 0.69 40
Bananas 0.34 38
Lemons 0.55 15
Oranges 0.25 25
Apples 0.5 10
Pears 0.59 40
Almonds 2.8 10
Cashews 3.55 16
Peanuts 1.25 20
Walnuts 1.75 12
Apples 0.5 5

Given the data above I'm trying to sum the totals for only the Appl
rows. So basically I need to search the Fruit column find the row
that have "Apples" and then sum their corresponding Totals, giving m
55. I've been playing with this for hours with Lookups and Indexes bu
am not really getting anywhere. Also, I cannot use any VBA as th
client will not run any files with Macros. Thanks in advance for an
assistance.
Gre

 

[VBA Noob]

Theres a few ways

Here's a few of them

1) You could use a pivot table

2) =SUMPRODUCT(--(A2:A12="apples")*(C2:C12))

3) =SUMIF(A2:A12,"Apples",C2:C12)

VBA Noo

 

[summergs]

That did it thank