| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif across multiple worksheets
I have worksheets for every month of the year, each with employee names and
totals. Is there a sumif variant I can use to go through these 12 worksheets? Ted |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif across multiple worksheets
Just to clarify -- one file with multiple tabs.
"Ted Metro" wrote: I have worksheets for every month of the year, each with employee names and totals. Is there a sumif variant I can use to go through these 12 worksheets? Ted |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif across multiple worksheets
A couple of ways:
http://www.mcgimpsey.com/excel/threedsumif.html In article , Ted Metro wrote: I have worksheets for every month of the year, each with employee names and totals. Is there a sumif variant I can use to go through these 12 worksheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort data on multiple worksheets | Excel Discussion (Misc queries) | |||
| SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
| Functions across multiple worksheets | Excel Worksheet Functions | |||
| Sumif with multiple worksheets | Excel Worksheet Functions | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
