What's wrong with this formula?

[Bishoop]

=SUM('Sep, ''03:Nov, ''03'!J39)

I trying to add the contents of cells J39 on worksheets Sep,'03 thru Nov,
'03. The actual result is only the contents of J39 on worksheet Sep, '03
and doesn't add the results from the other worksheets.

Can someone point out what the problem may be?

Thanks....

 

[Peo Sjoblom]

Let Excel do it, put =SUM in a cell, select the September sheet, assuming
that the next is oct and then nov
hold down shift while clicking on nov sheet tab, then click on J39 and press
enter and excel will
do the formula for you. Having said that I recommend you to use another name
format for sheet tabs,
that way it will be easier to use them in a formula. For instance instead of
Sep, "03 you could use
Sep03 instead. No spaces involved and no delimiters etc.


Regards,

Peo Sjoblom

 

[Arvi Laanemets]

Hi

=SUM('Sep,''03:Nov,''03'!J39) works for me! Check out, don't you have some
additional spaces in formula or in sheet names. Or remove all crap from
first and last sheets names (Sep03 and Nov03), get the working formula, and
afterwards edit sheetnames as you like - the formula'll adjust.

 

[Bishoop]

Dumb me. The cells I want to sum are located in the K column on the sheets
after Sep, 03.

Thanks for the replies.

Bishoop wrote:
|| =SUM('Sep, ''03:Nov, ''03'!J39)
||
|| I trying to add the contents of cells J39 on worksheets Sep,'03 thru
|| Nov, '03. The actual result is only the contents of J39 on
|| worksheet Sep, '03 and doesn't add the results from the other
|| worksheets.
||
|| Can someone point out what the problem may be?
||
|| Thanks....