count if two conditions in two arrays are true

G

Gary

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select random records by two conditions 1
sumif date is greater than or equal chosen date 2
SUMIF with 2 creteria one Name one DAte 1
COUNT for 2 or MORE CONDITIONS 5
how to compare two arrays? 1
Two conditions in one IF statement 2
Conditional formatting if three conditions are true 1
if multiple conditions are true, then copy the row to a new sheet 2

Top