Conditional count based on values in top row

[piannetta]

Hi,

I'm trying to count the number of times the letter "O" appears in any column where the first row =1, then 2, and so on:

I've been playing around with =countifs() and variations of nested =countif() without luck.

Does anyone have any tips to help me with this please?

Cheers,
Pete

 

[piannetta]

I think I've figured it out using the offset function:

=COUNTIF(OFFSET($LE$8,1,LF2,392,LG2-LF2),"O")

Where...
LE8 being the top-left corner outside of the range I'm interested in
LF2 = the number of columns in the count range (a formula that returns the starting column number of the next set of columns to be counted)
LG2 - LF2 = a formula to work out how many columns are in the count range