No can do. Try this withOUT entire columns.
=sumproduct((d2:d22="whatever")*(e2:e22=2))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.