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 Apple rows. So basically I need to search the Fruit column find the rows that have "Apples" and then sum their corresponding Totals, giving me 55. I've been playing with this for hours with Lookups and Indexes but am not really getting anywhere. Also, I cannot use any VBA as the client will not run any files with Macros. Thanks in advance for any assistance.
Greg
Bookmarks