Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic and manual calculations | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
options to update automatic links | Excel Worksheet Functions | |||
How can I find automatic links in an Excel-sheet? | Excel Discussion (Misc queries) | |||
find automatic page breaks | Excel Worksheet Functions |