[red apple] [buy] [no]

[red apple] [buy] [no]

[red orange] [buy] [no]

[red apple] [sell] [yes]

[red apple] [sell] [no]

[blue apple] [buy] [yes]

[the brackets do not appear--they are just to display here]

I want to know how many times does 'red' AND 'buy' AND 'no' appear in the same row.

I've tried this:

=COUNTIF(A1:A6,"*red*")*COUNTIF(b1:b6,"*buy*")*COUNTIF(C1:C6="*no*")

but it multiples the result

and this

=COUNTIF(A1:A6,"*red*")+COUNTIF(b1:b6,"*buy*")+COUNTIF(C1:C6="*no*")

but it adds the result.

The result should be '3'.

and I cannot get wildcards to work in:

=sumproduct(--(A1:A6="red"),--(b1:b6="buy),--(c1:c6="no"))

The database is 10,000's of cells, and impossible to sort. I have key words in each column and need to see how many times they appear in the same row.

many many many thanks!