0

I have a complicated budget spreadsheet which I update regularly. I have one sheet which is essentially just my bank ledger where I categorize all transactions & purchases. And then I have another sheet where I analyze all the data from the general ledger.

For example, I have budgeted $40 a month for parking. So in one column I have $40, in another column I have the total spent so far (=SUMIF('2022 General Ledger'!D:D,"Parking",'2022 General Ledger'!B:B)) and in the third column I have the estimated annual spend based on the spending so far this year (=AVERAGE(SUMIFS('2022 General Ledger'!B:B,'2022 General Ledger'!D:D, "Parking", '2022 General Ledger'!A:A, ">12/31/21", '2022 General Ledger'!A:A, "<02/01/22"),SUMIFS('2022 General Ledger'!B:B,'2022 General Ledger'!D:D, "Parking", '2022 General Ledger'!A:A, ">1/31/22", '2022 General Ledger'!A:A, "<03/01/22"),SUMIFS('2022 General Ledger'!B:B,'2022 General Ledger'!D:D, "Parking", '2022 General Ledger'!A:A, ">2/31/22", '2022 General Ledger'!A:A, "<04/01/22"))*12)

It has been working smoothly so far, except I just dropped the entire March ledger and March's data doesn't seem to be being picked up by the formulas. I can't figure out why, as March's data on the general ledger is formatted exactly the same way as all previous transactions.

Just trying to see if there's a way to click the cell with the formula and trace it to see if I can identify the problem. Any suggestions?

Alternatively, if anyone has a suggestion for how to format this spreadsheet better so I don't run into issues like this in the future that would also be appreciated!

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.