Sum Values after finding last cell

  • Thread starter Thread starter emm8080
  • Start date Start date
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
 
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
 
Back
Top