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

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

WOW!!!!!!!!!!

YAHOOOO!!!!!!!!!!!!!!

THANXXXXXXXXX!!!!!!!!!!!!!!!!!

"T. Valko" wrote:

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

Dear Mr. Valko,

I sure am thankful for your all your help. That was an excellent approach.

However, I have another question!

Suppose, I want to compute the weighted average rate. In other words yours
recommended

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

being divided by (A1+C1+E1). Any other similar special formula to sum-up the
components only if rate is availabale???

e.g. if D1 is blank or equal to zero corresponding number of units in C1 is
not considered in calculation of divisor for accurate weighted average rate.

"T. Valko" wrote:

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

Try this:

=SUMPRODUCT((MOD(COLUMN(A1:E1),2)=1)*A1:E1,(MOD(CO LUMN(B1:F1),2)=0)*B1:F1)/SUMPRODUCT(--(MOD(COLUMN(A1:E1),2)=1),--(B1:F1<0),A1:E1)

Biff

"FARAZ QURESHI" wrote in message
...
Dear Mr. Valko,

I sure am thankful for your all your help. That was an excellent approach.

However, I have another question!

Suppose, I want to compute the weighted average rate. In other words yours
recommended

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

being divided by (A1+C1+E1). Any other similar special formula to sum-up
the
components only if rate is availabale???

e.g. if D1 is blank or equal to zero corresponding number of units in C1
is
not considered in calculation of divisor for accurate weighted average
rate.

"T. Valko" wrote:

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

WOW!!!!!!!!!!

I CAN'T BELIEVE THIS!!!!!!!!!!!!!!

YAHOOOO!!!!!!!!!!!!!!

YOU ARE GREAT!!!!!!!!!!!!!!!!

YOU SURE HAVE MADE MY LIFE EASY!!!!!!!!!!!!!!!

THANXXXXXXXXX!!!!!!!!!!!!!!!!!


"T. Valko" wrote:

Try this:

=SUMPRODUCT((MOD(COLUMN(A1:E1),2)=1)*A1:E1,(MOD(CO LUMN(B1:F1),2)=0)*B1:F1)/SUMPRODUCT(--(MOD(COLUMN(A1:E1),2)=1),--(B1:F1<0),A1:E1)

Biff

"FARAZ QURESHI" wrote in message
...
Dear Mr. Valko,

I sure am thankful for your all your help. That was an excellent approach.

However, I have another question!

Suppose, I want to compute the weighted average rate. In other words yours
recommended

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

being divided by (A1+C1+E1). Any other similar special formula to sum-up
the
components only if rate is availabale???

e.g. if D1 is blank or equal to zero corresponding number of units in C1
is
not considered in calculation of divisor for accurate weighted average
rate.

"T. Valko" wrote:

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

Your'e welcome. Thanks for the feedback!

Biff

"FARAZ QURESHI" wrote in message
...
WOW!!!!!!!!!!

I CAN'T BELIEVE THIS!!!!!!!!!!!!!!

YAHOOOO!!!!!!!!!!!!!!

YOU ARE GREAT!!!!!!!!!!!!!!!!

YOU SURE HAVE MADE MY LIFE EASY!!!!!!!!!!!!!!!

THANXXXXXXXXX!!!!!!!!!!!!!!!!!


"T. Valko" wrote:

Try this:

=SUMPRODUCT((MOD(COLUMN(A1:E1),2)=1)*A1:E1,(MOD(CO LUMN(B1:F1),2)=0)*B1:F1)/SUMPRODUCT(--(MOD(COLUMN(A1:E1),2)=1),--(B1:F1<0),A1:E1)

Biff

"FARAZ QURESHI" wrote in message
...
Dear Mr. Valko,

I sure am thankful for your all your help. That was an excellent
approach.

However, I have another question!

Suppose, I want to compute the weighted average rate. In other words
yours
recommended

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

being divided by (A1+C1+E1). Any other similar special formula to
sum-up
the
components only if rate is availabale???

e.g. if D1 is blank or equal to zero corresponding number of units in
C1
is
not considered in calculation of divisor for accurate weighted average
rate.

"T. Valko" wrote:

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