Forum Discussion

3 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Aug 24, 2022
    If the cell you are looking at is A55 then something like: =A55-SUM(A$1:A54)
    • mtlbooks's avatar
      mtlbooks
      Copper Contributor
      Aug 24, 2022

      thanks! but I didn't specify my problem well I want in cell N6 a formula something like this: =m6-(the last entry in this column [in this case it's in m3])*L6 [in this case it should come out337.5]

      mtarler 

      • mtarler's avatar
        mtarler
        Silver Contributor
        Aug 24, 2022
        assuming you have excel 365:
        =(M6-XLOOKUP(1,--(M$1:M5>0),M$1:M5,0,0,-1))*L6