B20=IF($A20<>"",SUM(IF(FREQUENCY(IF($D$3:$D$15<=$A20,IF($E$3:$E$15>=$A20,MATCH($B$3:$B$15&$C$3:$C$15,$B$3:$B$15&$C$3:$C$15,0))),ROW($B$3:$B$15)-ROW($B$3)+1),$C$3:$C$15)),"")
Control+shift+enter
copy down
B20=IF($A20<>"",SUM(IF(FREQUENCY(IF($D$3:$D$15<=$A20,IF($E$3:$E$15>=$A20,MATCH($B$3:$B$15&$C$3:$C$15,$B$3:$B$15&$C$3:$C$15,0))),ROW($B$3:$B$15)-ROW($B$3)+1),$C$3:$C$15)),"")
Control+shift+enter
copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks