Countif problem

[Martin]

Worksheet B Column K contains Names that I issued a Corrective Report to. It
can contains more than 1 report for the same person.
Column AC shows the date that are returned to me and closed

How to do a summary in Worksheet A to count the number of report that is
return to me by the individual person? Thanks.

 

[Bob Phillips]

=SUMPRODUCT(--('[Workbook B.xls]Sheet1'!$K$2:$K$200="John"),--('[Workbook
B.xls]Sheet1'!$AC$2:$AC$200<>""))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)