I have created a tracking spreadsheet that tracks expenses for each month in certain categories. Some months, I don't have any expense for a category. The formulas I have created are set up to pull from other spreadsheets that are set up so that when I put in the current data, each month will update based on the dates when the expenses accrued.
So for one category if I don't the expense until Dec, but it was posted in July, my spreadsheet will update the July numbers to reflect it.
But I need to keep track of what my projections for the year are. So if I don't have any expense in July for a category, and it's Jan, I need to figure out what my possible expense would be if I keep my current average for the next 6 months (until the end of June).
I can't figure out how to get excel to ignore the zeros in the months that haven't happened, but include the zeros for the months that have happened, to create a projection formula.