| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif with auto filter | Excel Worksheet Functions | |||
| How do I run a filter then have my countif change? | Excel Worksheet Functions | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Linear Mode
