Hi
I have a range of date cells which cover several years and am currently using the following formula to calculate the number of unique days in a particular year, the dates are in the 01/01/2018 format, in this case 1992.
=SUM(--(FREQUENCY(IF(YEAR(Records!$F$2:INDEX(Records!$F:$F,COUNTA(Records!$F:$F)))=1992,Records!$F$2:INDEX(Records!$F:$F,COUNTA(Records!$F:$F))),Records!$F$2:INDEX(Records!$F:$F,COUNTA(Records!$F:$F)))>0))
This is entered using ctrl, shift, enter.
I would like to expand this so that it only counts that date if a value in a corresponding column of cells is >0, I'm tying myself in knots trying to do this.
I have a range of date cells which cover several years and am currently using the following formula to calculate the number of unique days in a particular year, the dates are in the 01/01/2018 format, in this case 1992.
=SUM(--(FREQUENCY(IF(YEAR(Records!$F$2:INDEX(Records!$F:$F,COUNTA(Records!$F:$F)))=1992,Records!$F$2:INDEX(Records!$F:$F,COUNTA(Records!$F:$F))),Records!$F$2:INDEX(Records!$F:$F,COUNTA(Records!$F:$F)))>0))
This is entered using ctrl, shift, enter.
I would like to expand this so that it only counts that date if a value in a corresponding column of cells is >0, I'm tying myself in knots trying to do this.
