CountIF with Multiple Conditions... again.

[MikeyFB]

Hello

I want to have a count if formula with multiple conditions.

I understand one solution is using SUMPRODUCT.

I want to count if the items are listed with "HA" in collumn G, "OK" in Collumn L and "Yes" in Collumn O.

I have the following but it returns 0 rather than 1.

=SUMPRODUCT(G2:G499="HA")*(L2:L500="OK")*(O2:O500="Yes")

Thoughts?

 

[mikerickson]

Those ranges are of different sizes.

 

[MikeyFB]

Ive changed the formula so the ranges match.

=SUMPRODUCT(G2:G500="HA")*(L2:L500="Access Failure")*(O2:O500="Yes")

But it still picks none up when i change all of them to the conditions.