Nested Countif?

Dan Shigley · Sep 11, 2003

Would anyone know how I would count a range with a
qualifying range. For instance, if a2:a6 = "Y" then
countif(b2:b6,"X"). Any assistance would be greatly
appreciated.

Aladin Akyurek · Sep 11, 2003

=SUMPRODUCT((A2:A6="Y")*(B2:B6="X"))

Ken Wright · Sep 11, 2003

=SUMPRODUCT((A2:A6="Y")*(B2:B6="X"))

Leo Heuser · Sep 11, 2003

Dan

One way:

=SUMPRODUCT((A2:A6="Y")*(B2:B6="X"))

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

HM · Sep 11, 2003

If I understood you correctly, try this one:
sumproduct((A2:A6="y")*(B2:B6="x"))

Nested Countif?

Dan Shigley

Aladin Akyurek

Ken Wright

Leo Heuser

HM