Simplify this formula

[Thomas Kuriakose]

Dear Faseeh,

The computation in row 18 is correct based on input value in D10, D11 & D14.

Thank you so much for this.

Now we need to get the results if D12 & D13 are not blank in row 18 to complete this.

Thanks once again.

with regards,
thomas

 

[Faseeh]

Hi Thomas.

Please see attachment

 

[Thomas Kuriakose]

Dear Faseeh,

Kindly check whether you have saved the file at your end. This is the same file as the previous.

It is not calculating for D13 & D14 in row 18. The new formula is only calculating for D15.



Kindly check.

thank you so much

with regards,
thomas

 

[Faseeh]

Please put this formula in D19 with Ctrl+Shift+Enter and drag to left

=SUMPRODUCT((D10:D11*'Data Validation & Input Sheet'!$J$3:$J$4))+SUMPRODUCT((TRANSPOSE(D13:D15)='Data Validation & Input Sheet'!$G$3:$G$9)*('Data Validation & Input Sheet'!$H$3:$H$9))*D12

 

[Thomas Kuriakose]

Dear Faseeh,

Thank you so so much for this solution. Thank you so much for the patience and time you have provide in resolving this.

Thanks a ton.

with regards,
thomas

 

[Faseeh]

Dear Thomas,

You are always welcome. Keep visiting.