I think you could eliminate the NOT function call:
=SUMPRODUCT(--ISNUMBER(SEARCH("green",A1:A8)),--(B1:B8="approved"))


"Elkar" wrote:

If you have more than one criteria, use the SUMPRODUCT function. Try this:

=SUMPRODUCT(--(NOT(ISERROR(SEARCH("green",A1:A8)))),--(B1:B8="approved"))

HTH,
Elkar


"RegRat" wrote:

Would someone please show me how to write an equation to count the number of
entries that meet more than 1 condition. I need to count the number of any
COLOR of "green" with an "Approved" STATUS (answer: 3)? Thanks a bunch,
A B
1 COLOR STATUS
2 Yellowgreen Pending
3 Green Approved
4 Green Pending
5 Bluegreen Approved
6 Red Approved
7 Yellow Approved
8 Green Approved
9 Bluegreen Pending