Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there a way to sum totals based on multiple matches? Say in the following
example, from a separate sheet, i want to sum up the totals for stationary on the first sheet. e.g. Expense Type Total stationary £15 car £140 instruments £150 stationary £25 ....so I want to return the 15+25 based on a lookup (assume lookup value to be a given/stated i.e. "stationary"). Range will be constant size and named e.g. "JanExpenses" N.b. there will be 12 sheets, each with similar lists (1 for each month) which i would then need to sum, so the above might just be for January. I would then want to add this to Feb-Dec returned totals thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP and multiple matches | Excel Discussion (Misc queries) | |||
Displaying multiple matches | Excel Worksheet Functions | |||
Multiple Matches | Excel Worksheet Functions | |||
Multiple matches using LOOKUP | Excel Worksheet Functions | |||
Multiple matches on VLOOKUP | Excel Worksheet Functions |