MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Accumulative totals

Posted by Clyde on October 23, 2001 11:35 PM

Hi everyone. I am fairly new toi Excel but I have a problem.

I have cell A, B and C. The user ads data to A and B, and in C is a formula of the sum of A and B. The problem is that every end of the month the user delete's A and B and enter new values in both. The user don't want C to change but add the the sum of the new A and B plus the old value in C.

How can I do this. Please email solution to


Posted by Mark W. on October 24, 2001 5:39 AM

Enter =SUM(OFFSET(C1,0,-2,1,2)) into cell C1 and
copy down.