Excel 2007 : Vector Calculations

Given you've asked this question in a separate thread (which is preferable)

http://www.excelforum.com/excel-gene...culations.html

I would suggest you denote this particular thread as Solved.

Though FWIW in case anyone should find this:

G10:
=SUM(($D$10:$D10*LOOKUP($B10-$B$10:$B10,{0,5,8},$A$1:$A$3))*IF($B10-$B$10:$B10>=8,INDEX($C$10:$C10,1+ROW($C10)-ROW($C$10))*300,1))
confirmed with CTRL + SHIFT + ENTER
copied down