Jul 07 2021 10:17 PM
Hi All,
Looking for some help to find the correct formula to assist with this budget sheet issue. I have attached an example similar to the one I am trying to solve. I am looking to have a front reconciliation tab that auto calculates the total expenses by financial quarter against specific accounting code criteria (code1, code2, code3 etc.). The budget is managed weekly (52 weeks in total across a 4 quarter financial year) - please note the attached example only goes up to 20 weeks due to laziness!
- Jessica (Australia)
Jul 07 2021 11:02 PM
Check the attached WB, I've used SUMPRODUCT function in SUMMARY Sheet, and it gets the required data from DATA sheet.
** Please mark my post as Best Answer as well Like, since it solves the issue.
Oct 18 2021 11:58 AM