I have posted this earlier but did not get any reponse, hopefully I
have simplyfied it here, here is what I want VBA to do. I have 2
sheets a "Summary" and a "Phase1" work sheet:

Range on the "Summary" work sheet is E3:BY139

I want to copy the Formula as an array below, starting in Cell E3 then
copy and paste it as a value before moving to next cell which could be
either E4 or F3. This loop should go on until the last cell i.e.
E139.

Now CEP1, CCP1, DTP1 and RGP1 are all named ranges where Phase1 is
another sheet

CCP1 = Phase1!$C$3:$C$150
CEP1 = Phase1!$B$3:$B$150
DTP1 = Phase1!$E$2:$BV$2
RGP1 = Phase1!$E$3:$BV$150

Formula entered as an array in Cell E150:
{=SUM(IF(CEP1=$B3,IF(CCP1=$C3,IF(DTP1=E$11,RGP1,0) ,0),0))}

Can someone please help me on this one, Many Many thanks in advance

Edward