AVERAGEIF TROUBLES

[standw01]

I was doing my mothers budget and thought it would be a good idea to have each months predicted and actual expenses roll up into another sheet so she could see what her avearge bill would be year to date. Here is the formula that is currently in there...=AVERAGE('NOV 24'!C4,'DEC 24'!C4,'JAN 25'!C4,'FEB 25'!C4,'MAR 25'!C4,'APR 25'!C4,'MAY 25'!C4,'JUN 25'!C4,'JUL 25'!C4,'AUG 25'!C4,'SEP 25'!C4,'OCT 25'!C4,'NOV 25'!C4,'DEC 25'!C4). The problem is that it is averaging based off twelve months. I am trying to get the formula to exclude the months that have not happened yet. I tried Averageif to exclude zeroes, but it keeps giving me errors. I'm sure this is easy for most on here, but I am stumped.

 

[AhoyNC]

Try:

SUM('NOV 24:DEC 25'!C4)/COUNT('NOV 24:DEC 25'!C4)

 

[kvsrinivasamurthy]

Instead of 0 if the cell C4 is blank then result will be ok.

 

[AhoyNC]

​

kvsrinivasamurthy is right that the average function will ignore blank cells.
My formula in post 2 will not work if there is a 0 in cells C4.
If you can change the cells in C4 to blank if there is no data or if you have a forumla in cells C4 maybe make it an IF forumla that makes the cell blank if there is no data.
Then you should be able to change your formula to:
AVERAGE('NOV 24:DEC 25'!C4)