need help on a fomula

New Contributor

there is a way to calculate a cell substract the whole column above?

3 Replies
If the cell you are looking at is A55 then something like: =A55-SUM(A$1:A54)

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]

‏‏צילום מסך (13).png

@mtarler 

assuming you have excel 365:
=(M6-XLOOKUP(1,--(M$1:M5>0),M$1:M5,0,0,-1))*L6