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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif across workbook tabs
Are your sheet names really Sheet1, Sheet2, Sheet3 etc ?
Biff "tj" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif across workbook tabs
Hi
You could achieve this a different way. Create 2 new sheets called First and Last and drag these to positions where they "sandwich" the set of sheet you wish to sum, but not your Summary sheet. On your Summary sheet, use the formula =SUM(First:Last!A1) etc. to calculate the various totals required. Now, dragging any individual sheet to a position outside of the sandwich will exclude it from the summation. -- Regards Roger Govier "tj" wrote in message ... 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? |
Reply |
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 |