My formula is:
=AVERAGE(IF(($F$3:$F$100=”regular”)*ISNUMBER($E$3:$E$100),$E$3:$E$100))
How do I add string return if error. I get #DIV/0! error if no entries in “E” associated with “F” [regular] and would like it to return a string message instead of this error. I have played with ISERROR, but not successfully, my syntax is awry somewhere.
My attempt is: broken into 2 lines for forum
=IF(ISERROR(AVERAGE(IF(($F$3:$F$100=”twin”)*ISNUMBER($E$3:$E$100),$E$3:$E$100))
,”string”,AVERAGE(IF(($F$3:$F$100=”twin”)*ISNUMBER($E$3:$E$100),$E$3:$E$100)))
