Using count for an AND statement

A

anamarie30

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"))))

Thanks
 

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

Conditional function with count 6
Using <= in countifs statement 1
Incone & Expenses Statement 0
Excel formula to count the number of records which contains a certaintext (wildcard) 3
Macro to Select text from a point given to a specific word 2
VBA Syntax for Countif condition where only 1st char in Range of each cell = "M" 5
Why does this COUNTIF code not work 5
Compute Additional Hours Needed Using "if" or "lookup" 1

Top