=Countif help - two conditions

[dshilan]

Hi,

I am just trying to do a countif based on two criteria, both words.

So Column A has "H" and Column C has "Open"

As below - how can I coubt based on these two columns


H Open
M Open
H Closed
L Closed

[zbor]

Try =SUMPRODUCT(--(A1:A1000="H"), --(C1:C1000="Open"))

[Fotis1991]

Hi

You mean something like this?

=SUMPRODUCT(($A$1:$A$20="H")*($C$1:$C$20="Open"))

[dshilan]

Thanks a lot guys