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