simple question about SUM

[Farshad-1349]

Hi,

do yo know what is the best formula to replace for this basic formula on last row of table? 

I do not want to add a column, there should be something for it.

                A                   B                              C                                   D

1             50                  24                             0                                   12

2           100                  0                              15                                 13

3          Total   =(A1*B1)+(A2*B2)     =(A1*C1)+(A2*C2)    =(A1*D1)+(A2*D2)

[#2]

Do you want to try SUMPRODUCT Function?

[#3]

Hi @Farshad-1349

Are you asking for a formula to be able to autofill (drag across) that will calculate the fields automatically for each column?

If so, try =($A$1*B1)+($A$2*B2) and the drag this across to the right. A variant is =SUM($A$1*B1, $A$2*B2).

If I have understood wrong, please let me know?

Cheers

Damien