| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional function with count
Xl 2007
=COUNTIFS(M!E2:E37,"P",M!L2:L37,"Y") "anamarie30" wrote: Hi, I tried to make a formula that count if two statements are true. For example, =COUNTIF(M!E2:E37,"P") This formula give me the correct number that is 7. =COUNTIF(M!L2:L37,"Y") This formula give me the correct number that is 25. Then, I tried to combined this 2 formulas for using a conditional statement AND, because I want that the formula count when this 2 statements are true. =AND((COUNTIF(M!E2:E37, "P")), (COUNTIF(M!L2:L37, "Y"))) Result: True Then, I tried to make the count if this condition are True, but the count give a wrong number. The formula that I tried is =COUNT(AND((COUNTIF(M!E2:E37, "P")), (COUNTIF(M!L2:L37, "Y")))) Somebody can help me. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's the best way to count conditional formats? | Excel Discussion (Misc queries) | |||
| Conditional Count 2 Columns | Excel Worksheet Functions | |||
| Conditional Count | Excel Worksheet Functions | |||
| Using Count function with a conditional range | Excel Worksheet Functions | |||
| conditional count | Excel Worksheet Functions | |||
Threaded Mode
