countif every nth cell in row confusion

Hey there all,

It has been a while since I've done any excel programing and I feel like I knew this once, but not any more. I'm trying to COUNTIF every 6th non blank cell from H4 to IT4. Each of these cells have an IF statement in them that returns an "X" if true and leaves blank if false. So it only needs to count the number of X's. I've attached a small screen cap to help illustrate what I mean. Basically I need a better way of writing =COUNTIF(H4:IY4,"X") so that starting with cell H4 it only looks at every 6th cell. So H4, N4, T4, Z4, AF4,..........,IT4. In the examples below, the first would return 1 because N4 has an X and N4 does not. The second one would return 0 ignoring the other columns with X's in them in between.

Hopefully some part of that can be understood. Thank you for any help.

Try this:

=COUNTIFS(H4:IY4,"X",$H$2:$IY$2,1)

that works great. If I'm reading it right your saying count all the X's in row 4 if row 2 has a 1 in it. right?

Thank you so much.

Yes. .