Please take a look at the enclosed spreadsheet. In F5 I need an average of the three criteria found in column D (Job Subtype), the criteria being "Patient Transport", "Patient Assist" and "Blood Product Delivery". I've used the AVERAGEIFS formula you see to the right of the text box but because the criteria listed in column A (Job Subtype) doesn't have an entry for "Patient Assist", the formula returns a #DIV/0 value because of the zero value for "Patient Assist". Using IFERROR would only return a zero. Essentially, I need a formula that will overlook the fact there is no "Patient Assist" criteria to measure in column A but will still give me the overall average for the combination of "Patient Transport" and "Blood Delivery". Any help would be greatly appreciated.
Bookmarks