I excpect 2, because rows have the 2 conditions "mama" and "4"

"T. Valko" wrote:

COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"),

It depends on how you want this to count. You're referencing a 2 column
range with B5:C30. What result do you expect with this sample:

......B.....C.....E
......4.....4....Mama
......1.....4....Mama

Should the result be 2 or 3?

--
Biff
Microsoft Excel MVP


"orquidea" wrote in message
...
Hi:

How would I write A "COUNT IF AND" formula? I tried

COUNT IF AND(E5:E30,"MAMA"),(B:5:C30,"4"), but there is an error
somewhere.

Thanks in advance.
Escarly