Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up and total
I am putting together a budget sheet for a friend, I would like to
combine the budget template from MS's website and the Check book ledger template. I have added a category column to the ledger sheet. I want to budget sheet to search for these categories and bring back a total. Say, they have 3 entries for groceries, I want the budget sheet to total these three entries. How do I write a formula that totals all the lines that say groceries in it. I have too many categories for a large if statment. Thanks for the help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up and total
Hi!
Try this: =SUMIF(A1:A10,"groceries",B1:B10) If A1:A10 contains the entry: groceries, the corresponding cell(s) in B1:B10 will be summed. You can use a cell to hold the criteria: C1 = groceries =SUMIF(A1:A10,C1,B1:B10) Biff wrote in message oups.com... I am putting together a budget sheet for a friend, I would like to combine the budget template from MS's website and the Check book ledger template. I have added a category column to the ledger sheet. I want to budget sheet to search for these categories and bring back a total. Say, they have 3 entries for groceries, I want the budget sheet to total these three entries. How do I write a formula that totals all the lines that say groceries in it. I have too many categories for a large if statment. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grand total time between two total cells | Excel Discussion (Misc queries) | |||
Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
matching the column b(sku)c(count)with A | Excel Worksheet Functions | |||
Percent of total in Pivot tables | Excel Worksheet Functions |