One way

=SUMPRODUCT(--('C:\My Documents\[Murray Division
Pipeline.xls]Closed'!$B$1:$B$5000="Maxwell R"),--(MONTH('C:\My
Documents\[Murray Division Pipeline.xls]Closed'!$W$1:$W$5000)=10))


--

Regards,

Peo Sjoblom

"Jasmine" <Jasmine@discussions.microsoft.com> wrote in message
news:C7239223-3B31-4FF5-B72C-8D887973ACAD@microsoft.com...
> I am using the Sumproduct command to count the number of times a person's
> name shows up in my spreadsheet. It looks like this: SUMPRODUCT(('[Murray
> Division Pipeline.xls]Closed'!$B$1:$B$5000="Maxwell R")*1).
>
> I need to add an additional criteria to look for a specific month. In
column
> W there is a date field that I want to have it pull from. So I would want
to
> count all records that have Maxwell R in column B and are for the month of
> October in column W. Is there a way to do this with the Sumproduct
function?
> Thanks for the help!