Average If Certain Criteria is Met

Average If Certain Criteria is Met

edited 12/09/19 in Formulas and Functions

Hello,

I'm trying to calculate the average number of days but only for columns that meet the criteria.  I have a formula that is calculating the networkdays between two dates. This column is called Implementation Time (Days) - BD. I am now trying to average those days but only for when the Work Type column = Hospital Billing.  Does anyone have any advice?

I included a screen shot.

Thank you,

Sean

Hospital Billing.png

Tagged:

Best Answer

Answers

Sign In or Register to comment.