=IF(H10="",SUM(H11:INDEX(H:H,MIN(IF(H11:H1000="",R OW(H11:H1000))))),IF(G11="","",G11*IF(ISNA(VLOOKUP (F11,A:H,8,FALSE))=TRUE,VLOOKUP(F11,PRICING!A:C,3, FALSE),VLOOKUP(F11,A:H,8,FALSE))))

this is now an array formula, so commit with Ctrl-Shift-Enetr, not just
Enter.

--
__________________________________
HTH

Bob

"woozlemonk" wrote in message
...
I want to create an if statement in excel that fits into the following

=if(H10="",sum(H11:*****Here*****),IF(G11="","",G1 1*IF(ISNA(VLOOKUP(F11,A:H,8,FALSE))=TRUE,VLOOKUP(F 11,PRICING!A:C,3,FALSE),VLOOKUP(F11,A:H,8,FALSE))) )

where here is the next cell with a value of ""

which would effectively do the following and be a completely coded column
without any need for change


SUM
number
number
number
number

SUM
Number
Number
Number

SUM
Number
Number
Number
Number
Number
Number