May 04 2021 09:36 AM
May 04 2021 11:29 AM
SolutionLet'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)
May 05 2021 12:46 AM
May 04 2021 11:29 AM
SolutionLet'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)