count if two conditions in two arrays are true
 

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

count if two conditions in two arrays are true
 

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