=IF(B35="","",IF(COUNTIF('Input
Sheet'!$AN$3:$AN$5202,Filter!B35&"1")/(COUNTIF('Input
Sheet'!$AO$3:$AO$5202,Filter!B35))1,"Because "& B35&" has input hours into
future weeks their inputting completeness score is not
calculable.",COUNTIF('Input
Sheet'!$AN$3:$AN$5202,Filter!B35&"1")/(COUNTIF('Input
Sheet'!$AO$3:$AO$5202,Filter!B35))))

The above code in an excel cell counts entries against a persons name (in
this case in cell B35) and calculates the %age completeness unless there is
data filled in for weeks into the future.

It appears to use Filter( on the name in the cell) as the criteria for
COUNTIF but I can find no easy explanation. Can anyone help with the syntax
please.

Richard