If you have XL-2007 than you can use COUNTIFS fucntion otherwise use
SUMPRODUCT function

XL-2007
=COUNTIFS(D:D,"Criteria A",E:E,"Criteria A")


"Linar33" wrote:

I am trying to use the Countif function meeting two different criterias in
two different columns but I keep getting an error message. This is the syntax
I am trying to use:

=COUNTIF(D:D,"Criteria A"E:E,"Criteria B")

Please help me.

Thanks.