Excel function

T

T. Valko

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 ?
 
J

Jacob Skaria

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
 
B

bfrad

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
 
B

bfrad

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Indenting every other paragraph in Word at the same time? 0
Multiple IF Statement in Word 5
Searching for non-consecutive text 3
Word VBA - Automatic change content of a cell in table using dropdown list 5
Sharing Excel 365 Mac<->PC 0
Format column widths from one table to a separate table on same page 1
Need Help with a VBA subroutine 0

Top