Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Lock/Freeze cells in a formula

  1. #1
    New Member
    Join Date
    Oct 2014
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Lock/Freeze cells in a formula

    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

  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    39,421
    Post Thanks / Like
    Mentioned
    79 Post(s)
    Tagged
    16 Thread(s)

    Default Re: Lock/Freeze cells in a formula

    Does this formula in C1 do what you want?
    =SUM(OFFSET(C1,1,0,3,1))
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •