A slight correction for the upper range limit
(should be row 448 based on the last behaviour 7):

Put instead in F2:
=IF($B2="","",SUMPRODUCT((E$24:E$448<"")*($B$24:$ B$448=$B2),F$24:F$448))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---