I have my data laid out in the format as follows:

A B C D E F
90 10 200 11 450 8

In the above example columns A, C & E reflect the number of units while
columns B, D & F declare the selling rate per unit for the different products.

I need the amount of Total Sales in Column G and desparately need an array
type of special formula to compute (A1*B1+C1*D1+E1*F1) easily as the Actual
Data comprises of around 40 products containing around 40 different rates.

Help is desparately required and shall be highly obliged.

Thanx