getting the sum of the last 20 cells
 

Hi all,

I am a newbie to Excel VBA. I have a question for the
experts here. I have a table which keeps adding row entries
and it increases vertically. I want to get the sum of the last
20 entries (always the last 20 entries). How do I do that
and which command do I use? Thanks in advance.
Red

getting the sum of the last 20 cells
 

Hi,

No need for a macro ...
=SUM(yourcell:OFFSET(yourcell,-20,0))

HTH
Cheers
Carim

getting the sum of the last 20 cells
 

It worked! Thanks Carim

Carim wrote:
Hi,

No need for a macro ...
=SUM(yourcell:OFFSET(yourcell,-20,0))

HTH
Cheers
Carim