and this one in G2:

=B2*C2 + D2*E2

Copy these down the column - an easy way is to select F2 and double-
click the fill handle (the small black square in the bottom right
corner of the cursor). Then select G2 and do the same.

Hope this helps.

Pete

On Jul 23, 9:46 am, vlook fomula
wrote:
I have two diff things in two diff column and rage of columns are 30 I always
calculate manually by using +. Kindly advise me any easy formula and mention
the site of temples to look the flow of application

Examples
Total
Description Pack Kgs Pack kg Pack Kg

A123 2 400 1 200 ? ?
B123 1 200 3 600 ? ?
C123 5 1000 2 400 ? ?
D123 1 200 2 400 ? ?

Regards

Dear Sir,
the above application could not help me actually my english is not good pry
try to understand me, actually i want to apply formulla and want to get sum
of the add and even column sepectively .
regards

Put this in G2, then:

=C2 + E2

and copy down as before.

Hope this helps.

Pete

On Jul 24, 9:55*am, vlook fomula
wrote:


Dear Sir,
the above application could not help me actually my english is not good pry
try to understand me, actually i want to apply formulla and want to get sum
of the add and even column sepectively .
regards

"vlook fomula" wrote in message
...
and this one in G2:

=B2*C2 + D2*E2

Copy these down the column - an easy way is to select F2 and double-
click the fill handle (the small black square in the bottom right
corner of the cursor). Then select G2 and do the same.

You don't need F2 to select the fill handle, at least I never have.

sir, it is easy if i have only few column but as i told u that i have 30 or
some time more than 30 column then it is very defficult to use
=c2+e2+g2+i2...., i need some easy formula that can calculate alternate( or
many nos of add or even columns)
i saw in the diffirent results as sumproduct but how i can apply this
please help me

"Pete_UK" wrote:

Put this in G2, then:

=C2 + E2

and copy down as before.

Hope this helps.

Pete

On Jul 24, 9:55 am, vlook fomula
wrote:


Dear Sir,
the above application could not help me actually my english is not good pry
try to understand me, actually i want to apply formulla and want to get sum
of the add and even column sepectively .
regards

Bob,

only part of my earlier answer was repeated in this post. F2 was the
cell containing the formula, so this needed to be selected and then
the fill handle could be double-clicked.

Pete

On Jul 24, 10:10*am, "Bob Phillips" wrote:
"vlook fomula" wrote in message

...

and this one in G2:

=B2*C2 + D2*E2

Copy these down the column - an easy way is to select F2 and double-
click the fill handle (the small black square in the bottom right
corner of the cursor). Then select G2 and do the same.

You don't need F2 to select the fill handle, at least I never have.

Ah, I think I understand now. Use this to add up even columns:

=SUMPRODUCT((MOD(COLUMN(B2:L2),2)=0)*B2:L2)

and this for odd columns:

=SUMPRODUCT((MOD(COLUMN(B2:L2),2)=1)*B2:L2)

Adjust the ranges to suit the number of columns you have, and then you
can copy down.

Hope this helps.

Pete


On Jul 24, 10:15*am, vlook fomula
wrote:
sir, it is easy if i have only few column but as i told u that i have 30 or
some time more than 30 column then it is very defficult to use
=c2+e2+g2+i2...., i need some easy formula that can calculate alternate( or
many nos of add or even columns)
i saw in the diffirent results as sumproduct but how i can apply this
please help me



"Pete_UK" wrote:
Put this in G2, then:

=C2 + E2

and copy down as before.

Hope this helps.

Pete

On Jul 24, 9:55 am, vlook fomula
wrote:

Dear Sir,
the above application could not help me actually my english is not good pry
try to understand me, actually i want to apply formulla and want to get sum
of the add and even column sepectively .
regards- Hide quoted text -

- Show quoted text -

Dear Pete
thanks u very much for rply i got the result as u advise and i got the
result by using + as shon in the following sheet, i want to know how do i
apply formula of sumproduct such as
=SUMPRODUCT(--(MOD(COLUMN(A1:Z1),2)=1),A1:Z1)
in the following sheet when i use this it is showing array1.array2.array3
please help me again
1/7/2008 2/7/2008 31/7/2008 Total
No of Pack Kg No of Pack Kg No of Pack Kg No of Pack Kg
Cotton Type 1 1 500 2 350 1 500 4 1350
Cotton Type 2 2 250 1 50 2 300 5 600
Cotton Type 3 1 300 3 350 4 200 8 850
Cotton Type 4 4 800 4 500 1 50 9 1350
thanks and regards

"Pete_UK" wrote:

Bob,

only part of my earlier answer was repeated in this post. F2 was the
cell containing the formula, so this needed to be selected and then
the fill handle could be double-clicked.

Pete

On Jul 24, 10:10 am, "Bob Phillips" wrote:
"vlook fomula" wrote in message

...

and this one in G2:

=B2*C2 + D2*E2

Copy these down the column - an easy way is to select F2 and double-
click the fill handle (the small black square in the bottom right
corner of the cursor). Then select G2 and do the same.

You don't need F2 to select the fill handle, at least I never have.

I'm sorry, I don't understand what results you are getting. What do
you mean by "array1.array2.array3" ?

Anyway, I think your formula should refer to row 3, and the range
should start with B.

Pete

On Jul 24, 10:37*am, vlook fomula
wrote:
Dear Pete
thanks u very much for rply i got the result as u advise and i got the
result by using + as shon in the following sheet, i want to know how do i
apply formula of sumproduct such as
=SUMPRODUCT(--(MOD(COLUMN(A1:Z1),2)=1),A1:Z1)
in the following sheet when i use this it is showing array1.array2.array3
please help me again
* * * * 1/7/2008 * * * * * * * *2/7/2008 * * * * * * * *31/7/2008 * * * * * * * Total *
* * * * No of Pack * * *Kg * * *No of Pack * * *Kg * * *No of Pack * * *Kg * * *No of Pack * * *Kg
Cotton Type 1 * 1 * * * 500 * * 2 * * * 350 * * 1 * * * 500 * * 4 * * * 1350
Cotton Type 2 * 2 * * * 250 * * 1 * * * 50 * * *2 * * * 300 * * 5 * * * 600
Cotton Type 3 * 1 * * * 300 * * 3 * * * 350 * * 4 * * * 200 * * 8 * * * 850
Cotton Type 4 * 4 * * * 800 * * 4 * * * 500 * * 1 * * * 50 * * *9 * * * 1350
thanks and regards

Dear Sir,
Sorry for miscommunication, actually my question is: I have data in so many
columns and I want to apply a formula in the last column of total for
addition of alternate column
Please suggest me
thanks and regards
"Pete_UK" wrote:

I'm sorry, I don't understand what results you are getting. What do
you mean by "array1.array2.array3" ?

Anyway, I think your formula should refer to row 3, and the range
should start with B.

Pete

On Jul 24, 10:37 am, vlook fomula
wrote:
Dear Pete
thanks u very much for rply i got the result as u advise and i got the
result by using + as shon in the following sheet, i want to know how do i
apply formula of sumproduct such as
=SUMPRODUCT(--(MOD(COLUMN(A1:Z1),2)=1),A1:Z1)
in the following sheet when i use this it is showing array1.array2.array3
please help me again
1/7/2008 2/7/2008 31/7/2008 Total
No of Pack Kg No of Pack Kg No of Pack Kg No of Pack Kg
Cotton Type 1 1 500 2 350 1 500 4 1350
Cotton Type 2 2 250 1 50 2 300 5 600
Cotton Type 3 1 300 3 350 4 200 8 850
Cotton Type 4 4 800 4 500 1 50 9 1350
thanks and regards

If you are using 31 columns, this means your last column is AE, so put
this formula in AF3:

=SUMPRODUCT((MOD(COLUMN(B3:AE3),2)=0)*B3:AE3)

and this one in AG3:

=SUMPRODUCT((MOD(COLUMN(B3:AE3),2)=1)*B3:AE3)

Copy them down each column for as many rows are you are using.

Hope this helps.

Pete

On Jul 25, 9:19*am, vlook fomula
wrote:
Dear Sir,
Sorry for miscommunication, actually my question is: I have data in so many
columns and I want to apply a formula in the last column of total for
addition of alternate column *
Please suggest me
thanks and regards



"Pete_UK" wrote:
I'm sorry, I don't understand what results you are getting. What do
you mean by "array1.array2.array3" ?

Anyway, I think your formula should refer to row 3, and the range
should start with B.

Pete

On Jul 24, 10:37 am, vlook fomula
wrote:
Dear Pete
thanks u very much for rply i got the result as u advise and i got the
result by using + as shon in the following sheet, i want to know how do i
apply formula of sumproduct such as
=SUMPRODUCT(--(MOD(COLUMN(A1:Z1),2)=1),A1:Z1)
in the following sheet when i use this it is showing array1.array2.array3
please help me again
* * * * 1/7/2008 * * * * * * * *2/7/2008 * * * * * * * *31/7/2008 * * * * * * * Total *
* * * * No of Pack * * *Kg * * *No of Pack * * *Kg * * *No of Pack * * *Kg * * *No of Pack * * *Kg
Cotton Type 1 * 1 * * * 500 * * 2 * * * 350 * * 1 * * * 500 * * 4 * * * 1350
Cotton Type 2 * 2 * * * 250 * * 1 * * * 50 * * *2 * * * 300 * * 5 * * * 600
Cotton Type 3 * 1 * * * 300 * * 3 * * * 350 * * 4 * * * 200 * * 8 * * * 850
Cotton Type 4 * 4 * * * 800 * * 4 * * * 500 * * 1 * * * 50 * * *9 * * * 1350
thanks and regards- Hide quoted text -

- Show quoted text -

Thank you very much for this kind and my problem is solved. i wrote this
formula in the required cell and got result, but let me know that, is there
any methoud to choose the sumproduct in the existing sheet and can apply this
formula properly or a site where i can lern more about this formula

God Bless you

thanks and regards
Zafar
"Pete_UK" wrote:

If you are using 31 columns, this means your last column is AE, so put
this formula in AF3:

=SUMPRODUCT((MOD(COLUMN(B3:AE3),2)=0)*B3:AE3)

and this one in AG3:

=SUMPRODUCT((MOD(COLUMN(B3:AE3),2)=1)*B3:AE3)

Copy them down each column for as many rows are you are using.

Hope this helps.

Pete

On Jul 25, 9:19 am, vlook fomula
wrote:
Dear Sir,
Sorry for miscommunication, actually my question is: I have data in so many
columns and I want to apply a formula in the last column of total for
addition of alternate column
Please suggest me
thanks and regards



"Pete_UK" wrote:
I'm sorry, I don't understand what results you are getting. What do
you mean by "array1.array2.array3" ?

Anyway, I think your formula should refer to row 3, and the range
should start with B.

Pete

On Jul 24, 10:37 am, vlook fomula
wrote:
Dear Pete
thanks u very much for rply i got the result as u advise and i got the
result by using + as shon in the following sheet, i want to know how do i
apply formula of sumproduct such as
=SUMPRODUCT(--(MOD(COLUMN(A1:Z1),2)=1),A1:Z1)
in the following sheet when i use this it is showing array1.array2.array3
please help me again
1/7/2008 2/7/2008 31/7/2008 Total
No of Pack Kg No of Pack Kg No of Pack Kg No of Pack Kg
Cotton Type 1 1 500 2 350 1 500 4 1350
Cotton Type 2 2 250 1 50 2 300 5 600
Cotton Type 3 1 300 3 350 4 200 8 850
Cotton Type 4 4 800 4 500 1 50 9 1350
thanks and regards- Hide quoted text -

- Show quoted text -

Here is the definitive guide to SUMPRODUCT:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Hope this helps, and thanks for feeding back.

Pete

On Jul 25, 10:23*am, vlook fomula
wrote:
Thank you very much for this kind and my problem is solved. i wrote this
formula in the required cell and got result, but let me know that, is there
any methoud to choose the sumproduct in the existing sheet and can apply this
formula properly *or a site where i can lern more about this formula *

God Bless you

thanks and regards
Zafar