Multiple Functions

  • Thread starter Thread starter Linar33
  • Start date Start date
L

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: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))
 
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)
 
=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)
 
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")
 
Back
Top