Average If Certain Criteria is Met

Average If Certain Criteria is Met

edited 12/09/19 in Formulas and Functions


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,


Hospital Billing.png


Best Answer


Sign In or Register to comment.