Try like this:

=SUMPRODUCT(--(T6:T1147="Sent TP"),--(MONTH(S6:S1147)=MONTH(E3)))


"Gary" wrote:

rIn a previous post JMB said:
How many sales Brian had in January (2):
=SUMPRODUCT(--(A1:A5="Brian"),--(MONTH(B1:B5)=1))
I have a similar problem and have tried this:
=SUMPRODUCT(--(T6:T1147="Sent TP"),--(MONTH(S6:S1147)=E3))
My goal is to count the number of occurrences in T6 thru T1147 when a date
in S6 thru S1147 corresponds to the words "Sent TP" in column T having a
corresponding date that is greater or equal to a date in E3. E3 will contain
a date equal to the first day of the month being tested and is in the format
mm/dd/yyyy. So my goal is to count the number of occurences of "Sent TP" in
column T that occur in any particular month E3 in column S.