Forum Discussion
Help Wanted: conditional criteria for IFS-type functions
Excel 2013. How do I create an in-formula conditional criteria for an IFS-type function's criteria range based on subtracting a value from the value of the cell at the foot of the Criteria_range? Wh...
Use IFERROR before the AVERAGEIFS formula.
If average_range is a blank or text value, AVERAGEIFS returns the #DIV0! error value.
example:
=IFERROR(AVERAGEIFS(E1:E25,D1:D25,">(D25-7)"),"")
I would be happy to know if I could help.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.