Hi
no it doesnt in 2007 version. It always stuffs up

I am sorry to have to dispute you, but it does work in all versions of
Excel, including XL2007.
You have already proved it, if it works for
=SUM(JUNE07:MARCH07!F200)

I have 0 in the required cell for June07 so it all works out just the
way I want it to.
There doesn't need to be anything at all entered on any sheets, if you
haven't yet got to that month.

Still doesnt work unless you manually type the formula in.
I don't know what you mean by this.

As I offered before, if you want to send me a copy of the workbook, I
will take a look to see what is going on and send you back a working
copy.
To send direct remove NOSPAM from my email address

--
Regards

Roger Govier


"Diamontina Cocktail" wrote in message
...

"Roger Govier" wrote in message
...
Hi

I think you must be doing something wrong.
It works perfectly in all versions of Excel.

If you mean the drag over to indicate different sheets in one workbook
should have cells at a particular location added together to go into
this sheet, no it doesnt in 2007 version. It always stuffs up.
However, I used what you said and have this: =SUM(JUNE07:MARCH07!F200)
which works just fine. Anything between March07 and June07 fall into
line. I have yet to incorporate more data as previous to using Excel I
was doing it all on Word docs and manually adding it. I have 0 in the
required cell for June07 so it all works out just the way I want it
to.

The formula is only entered on the Summary sheet - nowhere else.

Yep, that is where I tried it. Still doesnt work unless you manually
type the formula in.

Sheets F and L have nothing at all on them.
What formulae you choose to have on any other sheets, is down to you,
but they would not include the formula I gave for the summary
=SUM(F:L!B2)


If you type it in like that, yes it works. If you hold the left mouse
button down and drag over each tab to highlight them, no it doesnt but
it is supposed to work that way.