On Mar 16, 6:16 am, Ailish wrote:
I justed wanted to ensure that if the person wanted to add some summary
analysis under the block that the formulae would still work on just that
contiguous block.

Any ideas,

Thanks
Ailish



"Bernard Liengme" wrote:
Why not =SUM(O13:O65536)
It does not matter that cells after the last one are blank
Or am I missing something?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ailish" wrote in message
...
Hi All

I am using Excel 2003, I want to put a formula on my spreadsheet in O9
that
will sum from O13 through to the last value in the column which changes
all
the time. I have tried using sum and offset but I just can't seem to get
it
to work.

Help please.
Ailish- Hide quoted text -

- Show quoted text -

You would need the user to right click - insert down and then type in
the value. That would expand the boundaries of the summary range.