IN DA HOUSE! formula help:)

[HUHandEH]

Hey guys, just wanted to say hi, send a hello to Hans, and any other Woody nuts that might of found their way here.

I have a question regarding a formula, I want to be able to count the number of times B column has X, and A column has Y.

my formula so far looks is a countif, how do I add the second condition to my formula for column A

=COUNTIF(B:B,"A OP") - how do I add Column A? with a countif condition, so that if both are true then I get my desired count?

Thank you in advance for you help.

Darryl.

[HansV]

Hi Darryl,

Welcome to Eileen's Lounge!

If you have Excel 2007 or later, you can use the new COUNTIFS function:

=COUNTIFS(A:A,"X",B:B,"Y")

In Excel 2003 or before, you must resort to a different kind of formula, for example

=SUMPRODUCT((A1:A1000="X")*(B1:B1000="Y"))

You can't use an entire column in this formula, you must specify a limited range.

[HUHandEH]

Thanks Hans,

You still Da Man when it comes to Excel:)

[HansV]

By the way, Darryl, notifications sent by our server to your e-mail address are being returned as undeliverable.
- Are you sure that you have provided the correct e-mail address? (Go to User Control Panel to check this)
- If so, could your mail box be full?
- Or could our e-mails be blocked as spam?

[HUHandEH]

just a test

[HUHandEH]

Thanks Hans, should be cool now:)

[HansV]

Looks OK - no more error messages!