How to use multiple SUM and MULTIPLY formulas in one cell as one "complex" math formula?

[ek6u]

Hello all,

I am writing to ask for your assistance/guidance on how to use multiple formulas in one cell.
I need to do something like =SUM(D3:I4)*20 (which works fine) but I need to do it multiple times for different range of cells in order to get the result in one cell from multiple additions and multiplications.
So I need something like (SUM of range of cells multiplied by a number/cell) + (SUM of range of cells * number/cell) + (SUM ofrange of cells * number/cell)
=SUM(D3:I4)*20 + =SUM(D5:I11)*25 + =SUM(D12:I18)*C12
OR
=(D3:I4)*20+(D5:I11)*25+(D12:I18)*C12

Would you please advise me if this is possible and if yes - how?
Thank you in advance!

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

[ek6u]

I was just about to attach a sample and then tried with "=SUM(D3:I4)*20+SUM(D5:I11)*25+SUM(D12:I18)*C12" and it worked fine. It was a syntax error (my bad - lack of knowledge). Please accept my apologies for taking your time checking this.