View original (French)

Keeping calculations constant

jack2125 Posted messages 486 Registration date   Status Member Last intervention   -  
PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   -

Hello everyone

Is there a way to keep my calculations consistent based on the last line written and the previous lines in my calculations?

You are awesome!
Thank you all

3 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     

    Hello

    Can you clarify your request and provide a specific example, because right now we don't understand.

    Regards

    Via

    0
  2. jack2125 Posted messages 486 Registration date   Status Member Last intervention  
     

    with the character $

    you are amazing!
    thank you all

    0
    1. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
       

      Hello.

      Are you sure about that?

      Send a file so we can work on it. And be sure to specify what you want to achieve!

      0
  3. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     

    Hello Jack2125

    There are several solutions

    1-° The $ example: =SUM($B$1:$B25) will sum the cells in column B from 1 to 25

    2-° Keeping example 1 and inserting 10 lines before line 25, the SUM will be on the new range $B$1:$B$35

    3-° By defining a name

    Formulas tab Name Manager

    Define a name

    same practice insert rows above the last line of the range to allow it to grow without having to modify the cell addresses

    0