Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Single Point Data Entry Worksheet? | Excel Discussion (Misc queries) | |||
Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) |