Hi!

Try this:

=SUMPRODUCT(--(D2:D146="open"),--(M2:M146="no"))

Biff

"Marilyn" wrote in message
...
I currently have a spreadsheet were Column D is set to Status and Column M
is
set to "YES" or "NO." Column D shows me if a Class is OPEN, CLOSED, OR
PENDING and Column M shows me if the Class is Required "YES" "NO"

I want to count the number of classes that are open and are not required.
Which means column D set to "OPEN" and Column M set to "NO"

I tried this formula but it is counting all the "NO" in column M:
=IF(AND(D2="open",M2="no"),COUNTIF(M2:M146,"no")," ")

I need a formula that will count between column D and M based on the
information.

Any Ideas?????

Thanks,