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,


+-------------------------------------------------------------------+
|Filename: Sample.doc |
|Download: http://www.excelforum.com/attachment.php?postid=5144 |
+-------------------------------------------------------------------+

 

[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 wante