Forum Discussion
Solved
Help, Countif
I have a current formula of =countif(‘sheetx’!C2:C15,1) which works fine. In the next cell down in the same column I need the exact same formula but with a reference of C16:C29 (and then following dow...
Let's say the first formula is in A2. Change it to
=COUNTIF(OFFSET('sheetx'!$C$2:$C$15, 14*(ROW(A2)-ROW($A$2)), 0), 1)
Let's say the first formula is in A2. Change it to
=COUNTIF(OFFSET('sheetx'!$C$2:$C$15, 14*(ROW(A2)-ROW($A$2)), 0), 1)
