[Solved] Sum if adjacent contains...

[illern]

Hi
I'd like to know if it's possible to sum a number (cost) if the adjacent cell contains a specific word.
Example:
On one tab I'd like to make a list of costs, like this:

Cost Item Category
10 Banana Fruit
23 Carrot Vegetable
5 Apple Fruit

One the next tab, I'd like to automatically search the list and sum the costs, in order to see how much I've currently spent on fruit, for example. So that I end up with a new list:

Category Total spent
Fruit 15
Vegetable 23

How do I do it?
Thanks

[FJCC]

SUMIF() will do the job with a formula like

Code: Select all

=SUMIF(Sheet1.C2:C4;A2;Sheet1.A2:A4)

Please see the attached document. To formula is on Sheet2.

[illern]

I love this forum!
Tremendous. Thank you!

[robleyd]

Another approach would be a Pivot Table formerly known as Data Pilot.