Hi

=SUMPRODUCT((S6:S1150="Sent TP")*1,(MONTH(R6:R1150)=D3)*1)

Regards,
Per

"Gary" skrev i meddelelsen
...
Using this formula to count the number of occurences when both conditions
are
true. Second condition compares dates in an array with a fixed date, say,
the
current month which is $D$3

=COUNT(IF(S6:S1150,"Sent TP")+IF(R6:R1150,=$D$3)).

So I want to know how many times the words "Sent TP" occur in the array
S6:S1150, when the dates in the array R6:R1150 equal the current month
$D$3