=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)



"Martin" wrote in message
...
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.