Excel Averageif help

[Elshe]

I need to work out an averageif calculation but I'm having an issue with future data.

So I get data on a weekly basis and log them column A, B, C, D etc. I don't get this in a monthly format so I want to add a calculation to find the average of ABCD (the weeks in Jan) and some will be blank.

Easy, do an Averageif but when I'm setting it up for the weeks that go into Jan, then Feb and so on, the cell that holds the AverageIF for the weeks in December are showing a DIV error.

I need to do it so the cell stays blank or gives you the average. At the end of each row I have an overall average for the year and with the DIV error that doesn't work.

This is what I currently have : =AVERAGEIF($E3:$H3,">0") Any suggestions?

 

[jasonb75]

How about

=IFERRORRAVERAGEIF($E3:$H3,">0"),"")

 

[Elshe]

How about

=IFERRORRAVERAGEIF($E3:$H3,">0"),"")

It wasn't quite it but I amended it to this, =IFERROR(AVERAGEIF($BA3:$BD3,">0"),"") and it works. Thanks for the point in the right direction. It's bugged me for weeks.

 

[jasonb75]

Oops, I didn't notice the typo in the formula when I posted it, glad you figured it out