Excel function
 

How I can SUM every other Column in the same row?

Excel function
 

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 ?

--
Biff
Microsoft Excel MVP


"bfrad" wrote in message
...
How I can SUM every other Column in the same row?

Excel function
 

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
---------------
Jacob Skaria


"bfrad" wrote:

How I can SUM every other Column in the same row?

Excel function
 

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

"T. Valko" wrote:

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 ?

--
Biff
Microsoft Excel MVP


"bfrad" wrote in message
...
How I can SUM every other Column in the same row?


.

Excel function
 

Try this:

=SUMPRODUCT(--(MOD(COLUMN(J6:HF6)-COLUMN(J6),2)=0),J6:HF6)

--
Biff
Microsoft Excel MVP


"bfrad" wrote in message
...
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

"T. Valko" wrote:

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 ?

--
Biff
Microsoft Excel MVP


"bfrad" wrote in message
...
How I can SUM every other Column in the same row?


.

Excel function
 

Thank you very much. It is working great.

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"bfrad" wrote:

How I can SUM every other Column in the same row?