Please help. I have a spread sheet that I am using to monitor a budget over the calendar year. I have all of the calculations to add up to the monthly invoice amounts in cells m26 - bl26. Since it is only February now, only January has been calculated and invoiced. All of the other monthly totals are still at $0.00.

I would like a cell that calculates the total spent “average” over the calendar year. I have this formula so far =SUM(M26:BL26)/12. The problem is, is that it calculates 1/12th of January’s total currently.

How do I correct the formula to calculate the average of only the cells that have dollar figures in them without having to modify the formula 12 times through the year?
KnK

=IF((B13>0),B13*2,“N/A”) for the entry (if the value is greater than zero do the calc, otherwise put in “N/A”) and then use AVERAGE(B1:B12) to get the average, since it will ignore the text strings.

Obviously adjust for your own values. Does this make sense?

If you change 12 in the formula =SUM(M26:BL26)/12 to (MONTH(NOW())-1) it will divide by the month number of last month, in February 1, in March 2 etc. Do you see how that works?