Excel function

  • Thread starter Thread starter bfrad
  • Start date Start date
How I can SUM every other Column in the same row?

Starting from what cell and ending at what cell?

A1:J1 ?
D15:IV15 ?
X101:DD101 ?
 
Is this what you are looking for

To sum the odd columns A,C,E....in the range A1:J1 try
=SUMPRODUCT((MOD(COLUMN(A1:J1),2)=1)*A1:J1)

and to sum the even columns in the range B,D,F ....
=SUMPRODUCT((MOD(COLUMN(A1:J1),2)=0)*A1:J1)

If this post helps click Yes
 
In my case it's stsrts from J6 the next one is L6, N6 and so on for the next
approx. 100 column approx. to HF6
 
Thank you very much. It is working great.

Jacob Skaria said:
Is this what you are looking for

To sum the odd columns A,C,E....in the range A1:J1 try
=SUMPRODUCT((MOD(COLUMN(A1:J1),2)=1)*A1:J1)

and to sum the even columns in the range B,D,F ....
=SUMPRODUCT((MOD(COLUMN(A1:J1),2)=0)*A1:J1)

If this post helps click Yes
Click to expand...
 
Back
Top