I am using the following formula to look up interview completes and applcations based on lead source:
=COUNT(IF(D2:D15116 ="International-Quinsteet",IF(K2:K15116="Interview Complete",L2:L15116)))+COUNT(IF(K2:K15116="Application Received",L2:L15116))
no matter what I try it returns the number 2.
Bookmarks