Simple problem (i think)

M

Mediaid

HELP!!!

I have virtually no knowledge of excel (which is a good start!)

What i have is a workbook with 16 sheets. On the front page i need
formula that will take a number from the same cell reference in eac
sheet.

Does that make sense???? (I'll put it another way)

On sheet one in F19 I need the sum of all the numbers in cell B23 fo
sheets 2-16.


:confused
 
M

mk

What i have is a workbook with 16 sheets. On the front page i need a
formula that will take a number from the same cell reference in each
sheet.

Does that make sense???? (I'll put it another way)

On sheet one in F19 I need the sum of all the numbers in cell B23 for
sheets 2-16.
Click to expand...
try =SUM('2:16'!B23)
I'm assuming 2, 3 ...16 are the sheet's names and they are in the same order
(from 2 to 16)

Marcin
 
V

vikrantgoswami

hi this is vikrant
i tried your this formula but it is not working
can u pls tell me in expanded form
 
N

Norman Harker

Hi Vikrant!

Perhaps it's better to remember the proper syntax:

=SUM('MySheet 2:MySheet 3'!B23)

The use of the two ' covers cases where there is a space in the sheet
name.
 
Top