Sum and Offset: to add from a point to the last entry in the colum
 

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

Sum and Offset: to add from a point to the last entry in the colum
 

=SUM(O13:O65536)


"Ailish" wrote:

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

Sum and Offset: to add from a point to the last entry in the colum
 

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

Sum and Offset: to add from a point to the last entry in the c
 

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

Sum and Offset: to add from a point to the last entry in the c
 

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.

Sum and Offset: to add from a point to the last entry in the c
 

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

This is a change from your original specs. Are you assuming that this
other person would leave at least one blank row between the data block
and the summary entries? Should such summary entries be excluded from
the sum? If so, try the array formula

=SUM(O13:INDEX(O13:O65536,MATCH(FALSE,ISNUMBER(O13 :O65536),0)))

This avoids volatile functions, like OFFSET. But if you want to use
OFFSET, try the array formula

=SUM(OFFSET(O13,0,0,MATCH(FALSE,ISNUMBER(O13:O6553 6),0),1))