Calculate each column with totals

I would like to calculate each pricing column with totals by using excel formula.

I currently have a sample excel data for your review:

Pricing: .12 | Pricing: .02 | Pricing: $2.00 | Pricing: .75 | Pricing: .08
Col1 | Col2 | Col3 | Col4 | Col5 Total
--------------|---------------| -----------------|----------------|----------------|-------------
12, 350 | 750 | 45 | 1,200 | 128 | 1,687.24
--------------|---------------|-----------------|-----------------|----------------|-------------
725 | 24 | 122 | 944 | 15 | 1,040.68
--------------|---------------|-----------------|-----------------|----------------|-------------

Totals: $2,727,92


What is the excel formula for giving results above table?

=SUM(Col1*.12, Col2*.02, Col3*2.00, Col4*.75, Col5*.08, Col1:Col5, Col6)
Not sure if this is correct formula for calculate my table.

Your help is really appreciated.

Thanks

Thanks for your quick response.

I've attached two sample worksheets for your review (one in picture and other it's book file.

sample.png

I would like a formula that calculates each row with totals

A2 12,3500*.12 = $1,482, B2 750*.02 = $15, C2 145*2.00 = $290, D2 1,200*.75 = $900, E2 128*.08= $10.24 which gives a total of $2,607.40 for the first row...

Thanks.

Yes, the total in F3 was incorrect.
Your formula works good, but I have many rows in worksheet and I would like to calculate all of them at once.

Your formula works good, but I have many rows in worksheet and I would like to calculate all of them at once.