Can we get a feature where folks can upload their docs and people can access them to make this easier? That would be BOSS.
So if I zeroed out all the expenses, and leave the budget that's what you'd want it to look at? Then your realized budget would be budget from months with revenue?
id add a tab that pulled Expenditures by month, then budget by month. then you could write it as =sumif(expenditures range,"<>", budget range). taht will just pull through the budget when expenditures is populated.
ohhh duh. you can also do it with out a new tab if you use an array formula. are you familiar?
i dont think taht will do it. just re-order it on a new tab.