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.

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.

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.

=SUMPRODUCT(--(D2:D200="Criteria A"),--(E2:E200="Criteria B"))

You have to pass explicit ranges, not whole colums, to SUMPRODUCT


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

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

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.