Sum totals

[Svgmassive]

I have recently re did a worksheet on the old worksheet i had the formula below that sum the employee totals for a given week.
=IF(COUNTA(INDEX($F$5:$F$12,MATCH(99^99,$A$5:$A$12,1)):INDEX($F$5:$F$12,ROW()))>0,SUMPRODUCT(--($F$5:$F$12=$F6),--($I$5:$I$12>=0),--($I$5:$I$12)))

my problem is the ranges are now reference different as listed below
$F$5:$F$7,$F$9:$F$12
can i get the formula corrected or is there another formula can perform the same function? thanks

 

[Aladin Akyurek]

You need to explain in words what the formula you posted is supposed to do.