Sum numbers in a column beyond a certain row, how to?

[marsup]

How to sum numbers in a column beyond a certain row?

 

[isabelle]

hi,

i don't know if i understand your question correctly,

=Sum(A1:A10)


--
isabelle



Le 2012-02-15 01:25, marsup a écrit :

 

[marsup]

hi,

i don't know if i understand your question correctly,

=Sum(A1:A10)

Thanks Isabelle, I am not looking to sum A1:A10, I wish to sum all
numbers say from A10 to beyond like A11, A12.. A13
as I keep adding as update. Hope I made this clear this time. Thanks.

Marsup

 

[isabelle]

ok i better understand, the last row filled in column "A" may be determined by the array formula
MAX(IF(A1:A65535<>"",ROW(A1:A65535)))
then to sum :

=SUM(INDIRECT("A1:A"&MAX(IF(A1:A65535<>"",ROW(A1:A65535)))))
array formula ---> validate with ctrl + maj + enter

--
isabelle



Le 2012-02-18 22:51, marsup a écrit :

 

[isabelle]

sorry,

validate with ctrl + shift + enter

--
isabelle



Le 2012-02-19 20:43, isabelle a écrit :

 

[isabelle]

also you can change

MAX(IF(A1:A65535<>"",ROW(A1:A65535)))
last value (text or number)

by,

=MAX(IF(ISNUMBER(A1:A65535),ROW(A1:A65535)))
last value (number)


or by,

=MAX(IF(ISTEXT(A1:A65535),ROW(A1:A65535)))
last value (text)



--
isabelle



Le 2012-02-19 20:55, isabelle a écrit :

 

[James Ravenswood]

=SUM(A:A)-SUM(A1:A10)

This will work whether you are using Excel 2003 or later versions