Using IF to run a formula to clean up #DIV/0!

[thoma011]

Hi All!
I'm cleaning up a simple sheet to calculate daily and weekly averages. I want to use the IF function to only run the AVERAGE of a range if any of the cells has data in it, but leave the cell blank if the entire range is blank. I've played around with a few variations, and still get those darn #DIV/0! cells.. lol

My range is E5:E9, and is part of a calendar, so there won't always be data in E5 (Monday).

Thanks!
T

[ORoos]

Try in B8: =IFERROR(AVERAGE(B3:B7),"")

[thoma011]

YES!! Thank you so much!!