Try something like this:

=SUMPRODUT((D1:D100="Criteria A")*(E1:E100="Criteria B"))

Adjust range references to suit your situation.

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Linar33" wrote in message
...
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.