Automatic Summations

[nizmo_gtr]

Please see attached file.

Can I get some help please. Im trying to set up excel to automatically do a summation of the "Cost" of each of the appropriate categories. For example, I want the cost of all "Lunch" items to be added up and displayed in the appropriate cell (H26). In other words, cell H26 should display $8 ($4 + $4), cell H16 should display $2, etc.

Thanks in Advance,

[Fusion_Guy]

A B C E
1 lunch 5 lunch 10
2 food 6
3 lunch 5


for col E, row 1 your formula is:

=SUMIF(A1:B3,D1,B1:B3)

[Fusion_Guy]

in other words

=SUMIF(whole_range,specific_category_string,cost_range)

whole_range = your whole table with the category and cost colum

specific_category_string = lunch

cost_range = range of all the $ values

[Fusion_Guy]

in other words

=SUMIF(whole_range,specific_category_string,cost_range)

whole_range = your whole table with the category and cost colum

specific_category_string = lunch

cost_range = range of all the $ values

[nizmo_gtr]

That is wicked. Thanks Fusion_Guy!!! Exactly what I wanted