AVERAGEIFS returns #div/0 but how do I make it just use zero?

[loveland517]

The following formula returns "#div/0"

=AVERAGEIFS(FILTERED!O:O,FILTERED!H:H,">="&TIME(0,0,0),FILTERED!H:H,"<"&TIME(7,0,0),FILTERED!O:O,">8")+AVERAGEIFS(FILTERED!O:O,FILTERED!H:H,">="&TIME(23,0,0),FILTERED!H:H,"<"&TIME(24,0,0),FILTERED!O:O,">8")

I understand the cause is due to the first argument in the formula...

=AVERAGEIFS(FILTERED!O:O,FILTERED!H:H,">="&TIME(0,0,0),FILTERED!H:H,"<"&TIME(7,0,0),FILTERED!O:O,">8")

...having no results returned (BACKGROUND: in the "FILTERED" sheet there are is no data to average in the O column that occurred from midnight to 7am that took over 8 hours)


How use I (within the same formula) express that it should just use "0" if the AVERAGEIFS formula returns "#div/0"?

 

[SQUIDD]

Can you not just wrap your formula in if error .

=iferror(your formula,0)

 

[etaf]

IFERROR

IFERROR ( Formula , 0 )

 

[loveland517]

Literally two seconds after posting I realized Not to wrap the entire formula, just the first part and it worked fine! THANK YOU ALL FOR BEING SO QUICK TO HELP ON THE WEEKEND!

 

[SQUIDD]

Your welcome.

Thanks for your feedback.