Multiple Functions

[Linar33]

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,"Criteria A"E:E,"Criteria B")

Please help me.

Thanks.

 

[Don Guillett]

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

 

[Ron Coderre]

Try something like this:

=SUMPRODUT((D1100="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)

 

[Bob Phillips]

=SUMPRODUCT(--(D2200="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)

 

[Teethless mama]

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

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