COUNTIF multiple range / multiple criteria

[fantom013]

I am trying to display a count of values in one column where another column has a different criteria.

example:
column A:A has COMPLETE or CANCEL

column H:H has 136-656 or 136-598 or 165-58

I want to find out how many rows have CANCEL in column A:A where column H:H = 136-598

Help??

[jasoncw]

=SUMPRODUCT((A1:A10000="CANCEL")*(H1:H10000="136-598"))

You may need to adjust the ranges. Sumproduct does not work with entire rows. HTH

Jason

[fantom013]

That did the trick. I was getting blindered by the COUNTIF function.