|
Using Filter as a criteria within COUNTIF
=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 |
Using Filter as a criteria within COUNTIF
It is looking for the value of the cell B35 on a sheet named filter.
-- Regards, Tom Ogilvy "Richard G" wrote: =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 |
| All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com