Forum Discussion

Mike_Schell's avatar
Mike_Schell
Copper Contributor
Jul 16, 2022

Can't seem to find the answer to a simple solution?

Hello,

 

Looking for a formula to display a changing value to show up in  one particular cell:

 

 

"E" column is a running total. What formula can I use in E10 (for example) to display to results of the running total without adding the numbers together.

For Example, E6 is 544. I know the simple code to display that particular value in E10 is =E6. 

But, when I add a new line next week (with a new value showing up in E7, now), how can I get E10 to display that new value while dismissing the previous week's total?

 

Formulas and Functions

14 Replies

    • Mike_Schell's avatar
      Mike_Schell
      Copper Contributor
      Jul 17, 2022

      HansVogelaar Wow, fantastic!! Thank you!!  I have no idea why that works reading the code but it does. Awesome!!

       

      • Mike_Schell's avatar
        Mike_Schell
        Copper Contributor
        Jul 17, 2022
        Hans,
        =LOOKUP(9.99999999999999E+307,E2:E9)

        Why "+307" in this code?? I am trying to get it to work in a totally different spreadsheet but having trouble getting it to come out right. Is the ...+307... germane only to the example I provided above or is it a universal value that can be used in any column application?

        Thanks

Resources