Summing distinct rows in same cell

  • Thread starter Thread starter summergs
  • Start date Start date
S

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
 
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
 
Back
Top