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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search for a sum! 4
In a sales quote sheet - sum totals by license type 1
counting formula 3
Clearing contents beyond the "Z" column 2
Formula for summing purchases and sales 8
Preserve number as text in Pivot table sum of values field 1
lookup and return column number 2
Trouble flagging conditions in Excel using VB 6

Back
Top