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