Trouble with count if formula

[CHEZMARANEY]

I am trying to write a formula for this: if cell in column H equals PD and if cell in column I equals C then count C's I tried using COUNTIF but can't get it to work

[Richard Buttrey]

You've hit the limitation of COUNTIF() with XL 2003 which is solved with the COUNTIFS() function in later versions.

You have a choice
=SUMPRODUCT((H1:H20="PD")*(I1:I20="C"))
change the range 1:20 as necessary

or use a helper column which concatenates column H & I and then you can use a COUNTIF looking for "PDC" in the helper column.

[CHEZMARANEY]

wesome, thanks!