Hi,
See file attached file.
With the attached file opened and the formula {=SUM(IF(($B$6:$B$10<=$H$6)*($B$6:$B$10>=$G$6);1/COUNTIFS($D$6:$D$10;$D$6:$D$10;$B$6:$B$10;"<="&$H$6;$B$6:$B$10;">="&$G$6));0)} in another workbook cell, it works ok.
What changes do I have to do, to make it work when the attached file is closed?
Regrads,
Elio Fernandes
Bookmarks