Sumproduct or vba

Hi All,
Wonder if anyone can help.
What I would like to do is to lookup the code in column A and return the result in column B.
I want to sum all values in column F when the code in column A has the following condition correct.
(i) Value in D is less than 2009012
(ii) Code in column A matches code in column E
(iii) Column G is either ATP or TTP. [Do not count all other types e.g. SSP]
For example for MAST01 result is 0 and MAYL01, result is 26,720.
Regards
Laylow

A B
CODE RESULT
MABE01
MABE02
MAST01
MAYL01



Column D ColumnE columnF columnG
PERIOD CODE VALUE TYPE
2008006 MABE01 40000 ATP
2008012 MABE01 45000 ATP
2009010 MABE01 15000 TTP
2008006 MABE01 50000 MMP
2008011 MABE01 50000 SSP
2009006 MABE02 50000 MMP
2010007 MABE02 50000 ATP
2011001 MABE02 110000 ATP
2008003 MABE02 55000 TTP
2011003 MABE02 55000 ATP
2010012 MAST01 14000 MMP
2009009 MAST01 43200 SSP
2010005 MAST01 27800 SSP
2008011 MAYL01 26720 ATP
2009005 MAYL01 37810 SSP
2011006 MAYL01 37810 TTP
2007012 MAYL01 62500 MMP