| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif across workbook tabs
I have a workbook of 10 tabs and need to be able to toggle whether or not to
include each tab in a summary presented in a separate tab. One idea was to toggle each tab on or off and use the sumif function to sum the data if the tab is toggled on (where 1 = on). My formula is: =SUMIF('Sheet1:Sheet10'!E6,1,'Sheet1:Sheet10'!F6). The result is a value error. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to sort the tabs in a workbook? | Excel Discussion (Misc queries) | |||
| Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
| CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
| sumif using other cell contents as workbook | Excel Discussion (Misc queries) | |||
| Setup Entire Workbook to print all tabs Duplex | Excel Worksheet Functions | |||
Threaded Mode
