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