I'm stuck big time and I'm not even sure how to explain it ... but here goes.
I need to use a formula that takes two different people, add all their transaction for a 30 day period, then subtract that amount from a starting balance. There isn't
a transaction for every day of the month and when there is one, it has to feed of
the remaining balance not the starting balance. Gosh, I hope that made sense???
The formula I came up with is:
IF((B1="Tom"),c1-Sumd1:d31, IF((B1="Pete"),c1-Sumd1:d31))
Column A is date, column B is person, column C is starting balance, column D is amount used, and column E is remaining balance.
Any help with be greatly appreciated.
Bookmarks