Formual to count

[rizmomin]

Hello:

Please refer to attached file.
Shee1 have Store Name in column A and Payroll date in Column B
I need formula to count the number of payroll date for a given store in sheet2 column A acrross the month in row 1.
I have manually added the numbers in sheet2.

Let me know if you have any questions.
Thanks.
Riz

[daffodil11]

B2:

=SUMPRODUCT((Sheet1!$A$2:$A$7=Sheet2!$A2)*(TEXT(Sheet1!$B$2:$B$7,"mmm")=Sheet2!B$1))

Copy over and down

[rizmomin]

Hello deffodil11:

Works great ...Thanks a lot.

Ruz

[daffodil11]

Glad I could help out.