Hello, I'm trying to do an average of days (column D) based on criteria in column F. Column F can be several inputs, but I only want to use it if the cell contains "Investigating", "RC Identified" or "Pending Fix Verification".
When I use the AVERAGEIFS function individually for each of these, it provides the correct response. However when I use multiple criteria, I get a #DIV/0. The formula I am using is:
=AVERAGEIFS(D:D,F:F,"Investigating",F:F,"RC Identified",F:F,"Pending Fix Verification")
Any insight would be appreciated.
When I use the AVERAGEIFS function individually for each of these, it provides the correct response. However when I use multiple criteria, I get a #DIV/0. The formula I am using is:
=AVERAGEIFS(D:D,F:F,"Investigating",F:F,"RC Identified",F:F,"Pending Fix Verification")
Any insight would be appreciated.