Using the IF function when trying to average a range of data

[kimteets]

I need to average a range of data; however, if there is no data in the range, I need to cell to be blank instead of the #DIV/0 error.

I've been using different variations of the IF function, but haven't been able to come up with the right calculation.

Below are a few I've used:

=IF(ISBLANK(F9:F13),"",AVERAGE(F9:F13)) (This gave me a #DIV/0 error, but calculated the average if there were numbers typed in the range.)


=IF(ISNUMBER(F9:F13),AVERAGE(F9:F13),"") (This blanked out the cell I wanted it to, but it didn't average the range of cells I wanted.)



Any ideas would be appreciated!

[Jonmo1]

Try

=IFERROR(AVERAGE(F9:F13),"")

[kimteets]

Thank you SO much! It works!

[Jonmo1]

You're welcome.