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 -