=SUMPRODUCT(--(MONTH(Sheet2!$A$1:$A$3)=B$1),--(Sheet2!$E$1:$E$3=$A2))

Assuming B1 contains the month (in number format Jan =1, Feb =2, etc) and A2
contains the service provider. Change the range references for Sheet2 as
needed.

Alternatively:
=SUMPRODUCT(--(TEXT(Sheet2!$A$1:$A$3,"MMM")=B$1),--(Sheet2!E$1:$E$3=$A2))

using same assumptions as above, but using "Jan" "Feb", etc (text format
instead of numeric representation).



"RUSH2CROCHET" wrote:

Hello All:

Quick question on SumProduct...
Sheet 1 is a recap of processed returns for customers
A1=Sprint
A2=Verizon
Column B is January
Column C is February, and so on

Sheet 2 is a "tracking log" of returns
Column A contains the Date value, including month & year
A1 = January 13 - E1 contains "Sprint"
A2 = February 2 - E2 contains "Verizon"
A3 = March - E3 contains "Sprint"

I would like Sheet 1 to reflect the number of transactions within a specific
month per customer, that is to say....

Jan Feb Mar
Sprint 1 1
Verizon 1


All suggestions welcome!

Thanks!
Sandi