How to Total Count If

[Certificates!]

I have got lost with what I suspect is a simple query. I want to get a total of a number of Countif calculations.

This works but is extremely cumbersome. Is there a better way? h18 =F18 is deliberately omitted.

=COUNTIF(H9,F9)+COUNTIF(H10,F10)+COUNTIF(H11,F11)+COUNTIF(H12,F12)+COUNTIF(H13,F13)+COUNTIF(H14,F14)+COUNTIF(H15,F15)+COUNTIF(H16,F16)+COUNTIF(H17,F17)+COUNTIF(H19,F19)+COUNTIF(H20,F20)+COUNTIF(H21,F22)+COUNTIF(H23,F23)+COUNTIF(H24,F24)+COUNTIF(H25,F25)+COUNTIF(H26,F26)+COUNTIF(H27,F27)

Thanks very much.

 

[ETAF]

how about
=SUMPRODUCT(--(H9:H27=F9:F27)*(H9:H27<>""))
if an older version of excel - which does not automatically setup as an array
Use control+shift+enter
and get {} around the formula

otherwise - what version of excel ?
and perhaps a sample example attached

 

[Certificates!]

Thanks, I'll give it a shot. I'm using Excel 2013

 

[ETAF]

ok on 2013 version you will need

Use control+shift+enter
and get {} around the formula

 

[Certificates!]

Thanks - I have sorted this and it works just fine.

 

[ETAF]

you are welcome