#DIV/0! Error when calculating averages over time

[jcarrara]

I am using the below average if formula to determine average employee performance rating.

I am trying to get rid of the #DIV/0! from cells where data has yet to be populated, as I want to set this up to be used in the following years and indicate an overall average.

=AVERAGEIF(B4:E4,"<>0")

I have been looking online the past hour and am having trouble incorporating a solution in to my existing formula.

I'm not sure if I am totally off base with my current formula.
I'm not well versed in Excel so everything it still baffling to me as far as complex formulas go.

https://ibb.co/cVW7D0

 

[Joe4]

Welcome to the Board!

Here is one way:

=IF(COUNT(B4:E4)>0,AVERAGEIF(B4:E4,"<>0"),"")

 

[jcarrara]

Welcome to the Board!

Here is one way:

=IF(COUNT(B4:E4)>0,AVERAGEIF(B4:E4,"<>0"),"")

Thank you! However it is still giving me the DIV/0! error if there are no numbers in the cells.

 

[Joe4]

What exactly is in cells B4:E4?
It doesn't sound like they are really empty.

What does:
=COUNT(B4:E4)
return?

That counts how many of those cells have numeric entries.

 

[jcarrara]

Ah, you are correct! There were 0's as values so have no data at all made the formula work. Thanks so much for your assistance !

 

[Joe4]

You are welcome.