Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum same cell across multiple worksheet function does not work...
I am attempting to sum the numbers from the same cell on 20 worksheets. All cells have been formatted as a number and I am using the following formula =SUM('Protocol 1:Protocol 20'!D3). When information is entered it will not sum.
BTW all of the D3 cell's have a Vlookup formula in them. Can anyone help? EggHeadCafe - Software Developer Portal of Choice Send Screen Captures Into A Database http://www.eggheadcafe.com/tutorials...ures-into.aspx |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum same cell across multiple worksheet function does not work...
OK, formula doesn't sum, bur what really happens? Do you get an error message
or zero or what? Are you sure that Calculation is set to Automatic? Sheets Protocol 1:Protocol 20 have to be contiguously after each other without any other sheets between them! Your formula is correct, you have to seek the problem somewhere else. Regards, Stefi €˛R Hannah€¯ ezt Ć*rta: I am attempting to sum the numbers from the same cell on 20 worksheets. All cells have been formatted as a number and I am using the following formula =SUM('Protocol 1:Protocol 20'!D3). When information is entered it will not sum. BTW all of the D3 cell's have a Vlookup formula in them. Can anyone help? EggHeadCafe - Software Developer Portal of Choice Send Screen Captures Into A Database http://www.eggheadcafe.com/tutorials...ures-into.aspx . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
My copy worksheet function doesn't work | Excel Discussion (Misc queries) | |||
how do I copy multiple column widths from a worksheet in one work. | Excel Discussion (Misc queries) | |||
Number of worksheet tabs as cell value? ie 4 work sheets = 4 cell value | Excel Discussion (Misc queries) | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions |