On a spreadhseet running in Excel 2007, I have the following formula in cell D7, where it works just fine:
=COUNTIF(OFFSET($S$2112:$S$2211,,(ROW()-ROW($D$6))*4),"OPEN")
It looks at a column of OPEN and CLOSE texts and counts the number of OPEN, straightforward enough. So I took the OFFSET...