Formula for COUNTIF using AND

[astetler]

I have 2 columns of data. "Type" and "Status". "Type" has either "FG", "RM" or "WP" as the data. "Status" has either "O" (open) or "C" (closed). I am trying to create formula in another cell that will count how many "RM" are "O". I've tried several times with IF, COUNTIF, both using AND and cannot get it to work. Can someone help me please?

[sweep]

Hi, how about this?

=sumproduct((Type_range="RM")*(Status_range="O"))

eg

=sumproduct((A1:A100="RM")*(B1:B100="O"))

[NBVC]

With 2003, you need Sumproduct

e.g

=Sumproduct(--(A1:A100="RM"),--(B1:B100="O"))

adjust ranges to suit.

[Cutter]

You'll have to use SUMPRODUCT() in Excel 2003 because COUNTIFS() is not available.

Try

=SUMPRODUCT((range1="RM")*(range2="O"))

[Cutter]

@NBVC

Strike 3 - I'm out!

[astetler]

Thank you, thank you, thank you!!!!!