Why is this inconsistent - referencing a cell in multiple worksheets?

[abacchs]

Hello,

Can someone please explain to me/ help me to fix this problem I am having in Excel.

The working cell reference is

=SUM('P1 PART:P5 PART'!K24)+'P6 PART '!K24

The cell reference that DOES NOT WORK is

=SUM('P1 PART:P6 PART'!K24)


I get the #REF! error. I don't understand why. I have another cell just beside it where I am referencing 20 different worksheets - and it works fine:

=SUM('N1 NET:N20 NET'!K24)

It's like some kind of bug in Excel. I would prefer to have standard clean references/ formulas throughout the entire workbook.


Thank you!

 

[VoG]

I think that you need a space after P6 PART as in your first formula

=SUM('P1 PART:P6 PART '!K24)

 

[abacchs]

Thank you VoG!

Well for now, the space seems to work, but still I have the question as to why Excel is processing the other formula (N1 NET...) without problem. Should I just let this go, or is there a bug in my Excel program that needs to be updated? (I checked Windows update, but no Excel updates are reporting). This is just worrying me a bit, because of the importance/ and design of our workbook.

Again, just to remind you that this formula works just fine: =SUM('N1 NET:N20 NET'!K24) - no spacing

But according to your input, it really should be entered as: =SUM('N1 NET:N20 NET '!K24) - with the spacing

 

[VoG]

If your sheet names end with a space then you need the space in your formulas.