CountIF

[JK]

I should know this but don't....

I have values in cells C9:K9
I also have values in cells C20:K20

I want a count of the number of cells in C20:K20 where the
value in C9:K9 is not equal to the value of 5.

Thanks for your help. I'm brain-dead today.

JK

 

[Frank Kabel]

Hi
=SUMPRODUCT(--(ISNUMBER(C20:K20)),--(C9:K9<>5))

 

[JK]

That works! I don't know why that works but it did!

Thanks

J

 

[Frank Kabel]

Hi
for an explanation see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html