I’ve been using the Bill Payment Tracker from @jono with great results. Thanks!
In row 22, I tried to add a SUMIF above each month (columns H-S) to tally the Last Amount for all bills where a checkbox appeared but was unchecked, thereby displaying the remaining cashflow for that month.
I’m stymied because, while the value of H24:S is True for all cells containing a box with a check, the value is False for all cells with no check, even when no checkbox appears. Thus, a SUMIF totals all bills not checked, even when no bill is due for that month.
I’ve mined the helper data for another way to generate this sum, to no avail. Can anyone find the missing link, or suggest a workaround?
I like your idea of showing the remaining cash flow for each month. I think a way around the true/false flag can be found in the hidden column BF whose header is “Due & Not Paid”. Any month for any item that is “Due and Not Paid” has a value of TRUE.
There are twelve rows for every bill item so the formula will be a little different, but it should be doable.
That is a help, in that it does provide “due but not paid”. I would have to match the month, which I could probably figure out. However, that table contains no amount. I’d have to cobble the status and the amount from two tables. So far, that’s beyond my coding skills.