Automatic Summations
 

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 |
+-------------------------------------------------------------------+

--
nizmo_gtr
------------------------------------------------------------------------
nizmo_gtr's Profile: http://www.excelforum.com/member.php...o&userid=37090
View this thread: http://www.excelforum.com/showthread...hreadid=568178

Automatic Summations
 

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)

Automatic Summations
 

in other words

=SUMIF(whole_range,specific_category_string,cost_r ange)

whole_range = your whole table with the category and cost colum

specific_category_string = lunch

cost_range = range of all the $ values

Automatic Summations
 

in other words

=SUMIF(whole_range,specific_category_string,cost_r ange)

whole_range = your whole table with the category and cost colum

specific_category_string = lunch

cost_range = range of all the $ values

Automatic Summations
 

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


--
nizmo_gtr
------------------------------------------------------------------------
nizmo_gtr's Profile: http://www.excelforum.com/member.php...o&userid=37090
View this thread: http://www.excelforum.com/showthread...hreadid=568178