| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell - two conditions count if factors are true when negative nu | Excel Worksheet Functions | |||
| How to count multiple conditions that are "TRUE" | Excel Discussion (Misc queries) | |||
| if any of 3 conditions is true, then answer is true | Excel Worksheet Functions | |||
| Count Occurances if two conditions true | Excel Worksheet Functions | |||
| Count if 2 conditions are true | Excel Worksheet Functions | |||
Hybrid Mode
