count the number of populated cells in column N based on data in column D

Originally Posted by jason.b75

Using a similar method of formula construction to my earlier suggestion, in KPI's I5

=1-COUNTIFS(INPUT!$D:$D,C5,INPUT!$N:$N,"<>")/COUNTIF(INPUT!$D:$D,C5)

By making your 2 sheets more consistant when you enter the names, you could then use the fill handle to copy the formula down for the other sales execs.

I've completed the first column for you, hopefully that will guide you toward completing the rest.

Attachment 160787

Wow,

Thank you so much. I reckon I can complete it now.

Regards

Caroline