PDA

View Full Version : Formula Assistance Required



LutonBarry
10-29-2020, 01:25 PM
Folks,

Hope you can help. On the attached spreadsheet is a list of daily transactions the number of which varies. I have in Column E a formula that shows the final cumulative running total for that day.

What I would like is either a modification of this formula so it calculates the profit or loss from the previous days ending or a separate formula to do that in column F.

If that is possible.

Thanking you all in advance.

Barry.

Paul_Hossler
10-29-2020, 01:57 PM
I think a pivot table would be a lot easier to maintain and give you almost everything you wanted

27379

p45cal
10-31-2020, 11:35 AM
An unrefined formula (just the first one that worked), in a cell in row 2:

=IFERROR(E2-INDEX($C1:C$2,LARGE(IF(NOT(ISERROR(VALUE($E1:E$2))),ROW(E1:E$2)-1),1)),"")
copied down. It may need to be array-entered (Ctrl+Shift+Enter rather than the usual Enter) because I'm on Office365 and it behaves differently from some ealier versions.