sumproduct _zafar

[vlook fomula]

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

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

 

[Pete_UK]

Put this in G2, then:

=C2 + E2

and copy down as before.

Hope this helps.

Pete

 

[Bob Phillips]

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.

 

[vlook fomula]

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]

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

 

[Pete_UK]

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

 

[vlook fomula]

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]

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

 

[vlook fomula]

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]

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

 

[vlook fomula]

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]

Here is the definitive guide to SUMPRODUCT:

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

Hope this helps, and thanks for feeding back.

Pete