Simple problem (i think)

[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

 

[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.

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

 

[Norman Harker]

Hi Mediaid!

Try:

=SUM(Sheet2:Sheet16!B23)

 

[Mediaid]

Thankyou!

I was close but you guys get the cigar.

Cheers

 

[vikrantgoswami]

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

 

[VIKRANT]

IT IS WORKING
THX

 

[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.