Excel Formula Simplification

[acool]

Hi Everyone,

I am currently working on a data and am trying to simply a formula to get the desired end result in Cell D20. However, I would like to create a formula which excludes having to reference Columns A, B & D. Instead, would only like to use Cell A1-Sum(A4-20)*12, B1-Sum(B4-B20)*12, and Column C to to get to the end result in D20. Any help in creating this formula would be greatly appreciated. For reference, I have included my current formulas below. Thank You!

Formula in Column B: $B$1*$A4
Formula in Column D: $B4*$C4
Formula in D21: Sum($D4:$D20)*12

 

[Sam_D_Ben]

I am not sure if this work for you. Please try_

=SUMPRODUCT(((A4:B20)*12)*(C4:C20))

 

[acool]

I am not sure if this work for you. Please try_

=SUMPRODUCT(((A4:B20)*12)*(C4:C20))

Unfortunately, this did not work but I appreciate your help!

 

[Peter_SSs]

Formula in Column B: $B$1*$A4
Formula in Column D: $B4*$C4

Those formulas do not make sense to me in relation to your image.

$B$1*$A4 = 50%*0 = 0 (not 0.15 as shown) (Perhaps A4 is actually 0.3 formatted to show nearest whole number? But we don't know)

$B4*$C4 = 0.15*450 = 67.5 (not 135 as shown)

Perhaps you could give us the sample data and existing formulas with XL2BB so that we can be sure we are working with exactly the same thing as you?
You could also try to further clarify in words exactly what you are trying to achieve?