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

  • Thread starter Thread starter marsup
  • Start date Start date
hi,

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

=Sum(A1:A10)


--
isabelle



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

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

=Sum(A1:A10)
Click to expand...

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
 
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 :
 
sorry,

validate with ctrl + shift + enter

--
isabelle



Le 2012-02-19 20:43, isabelle a écrit :
 
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 :
 
=SUM(A:A)-SUM(A1:A10)

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