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!