Try this:

=SUMPRODUCT(((MOD(COLUMN(A1:E1),2)=1)*A1:E1)*((MOD (COLUMN(B1:F1),2)=0)*B1:F1))

Note how the ranges are staggered.

Biff

"FARAZ QURESHI" wrote in message
...
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