Sum Values after finding last cell

E

emm8080

How do I add the values in a column after first finding the last cell?


Column A
1
2
4
2


I want to add A2:last cell. The last cell will change as and when
add data.

Thanks

Emm
 
J

Juan Sanchez

Where are you going to write the sum formula...

If it is in a column different to A you can use:

=SUM(A:A) this way you will sum everithing in column A.

If it is going to be at the end, next to the last cell you
might need to write the formula again each time or insert
rows before the formula, this way the formula will
actualize.

One more usefull thing ALT + =(Equal Sign) is a shortcut
for the autosum formula...

Cheers
Juan
 

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

Cell data entering slow! 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Problem with formula for finding last greater than/less than or equal to value 2
How do I unhide a row when ENTER is pressed in a certain cell? 6
Fill cells based on the other 3 cells unique combination the value on the target cell 0
Excel does not accept text format! 0

Top