Lock/Freeze cells in a formula

Calibre16

New Member
Joined
Oct 19, 2014
Messages
49
Hi,

In Cell C1, I need a formula that sums C2:C4, but each week, I need to add a new row of data ontop of C2.
The data in C4 should shift out of the locked cells.

I need to know the most current 3 weeks performance.

help appreciated.

Cal
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,419
Office Version
365
Platform
Windows
Does this formula in C1 do what you want?
=SUM(OFFSET(C1,1,0,3,1))
 

Watch MrExcel Video

Forum statistics

Threads
1,095,615
Messages
5,445,494
Members
405,335
Latest member
Thomanji

This Week's Hot Topics

Top