D
Debra Dalgleish
To simplify the calculation, you could add a formula in column N, with
the heading "Closed By":
=IF(L2<>"Closed","",IF(M2="",K2,M2))
This would calculate the name of the person who closed the file.
Then, count the names in that column, using a COUNTIF formula. For
example:
=COUNTIF(N2:N1669,P2)
Where P2 contains a name.
the heading "Closed By":
=IF(L2<>"Closed","",IF(M2="",K2,M2))
This would calculate the name of the person who closed the file.
Then, count the names in that column, using a COUNTIF formula. For
example:
=COUNTIF(N2:N1669,P2)
Where P2 contains a name.