Remember Me?

 dhodges00 Posts: n/a How can I add non-adjacent cells with a formula

I have 24 columns. In columns 25 and 26, I want the sum totals of every other
column to its left. In other words, column 25 would show the sum of columns,
1,3,5,7,... and column 26 the sum of columns 2,4,6,8,....

I have manually entered the formula =sum(a1+c1+e1+.....x1). Is there an
easier way?

 JulieD Posts: n/a Hi

to sum the EVEN columns
=SUM(IF(MOD(COLUMN(A1:X1),2)=0,A1:X1,0))

to sum the ODD columns
=SUM(IF(MOD(COLUMN(A1:X1),2)=1,A1:X1,0))

NOTE: these are array formulas so they need to be entered with control &
shift & enter, not just enter.

Cheers
JulieD

"dhodges00" wrote in message
...
I have 24 columns. In columns 25 and 26, I want the sum totals of every
other
column to its left. In other words, column 25 would show the sum of
columns,
1,3,5,7,... and column 26 the sum of columns 2,4,6,8,....

I have manually entered the formula =sum(a1+c1+e1+.....x1). Is there an
easier way? 1]

=SUMPRODUCT(--(MOD(COLUMN(\$A\$1:\$X\$1)-CELL("Col",\$A\$1)+0,2)=0),\$A\$1:\$X\$1)

2]

=SUMPRODUCT(--(MOD(COLUMN(\$A\$1:\$X\$1)-CELL("Col",\$A\$1)+1,2)=0),\$A\$1:\$X\$1)

dhodges00 wrote:
I have 24 columns. In columns 25 and 26, I want the sum totals of every other
column to its left. In other words, column 25 would show the sum of columns,
1,3,5,7,... and column 26 the sum of columns 2,4,6,8,....

I have manually entered the formula =sum(a1+c1+e1+.....x1). Is there an
easier way?

 RagDyeR Posts: n/a For a non-array option, you could try:

Odd columns:
=SUMPRODUCT((MOD(COLUMN(A1:X1)+1,2)=0)*(A1:X1))

Even columns:
=SUMPRODUCT((MOD(COLUMN(A1:X1),2)=0)*(A1:X1))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"JulieD" wrote in message
...
Hi

to sum the EVEN columns
=SUM(IF(MOD(COLUMN(A1:X1),2)=0,A1:X1,0))

to sum the ODD columns
=SUM(IF(MOD(COLUMN(A1:X1),2)=1,A1:X1,0))

NOTE: these are array formulas so they need to be entered with control &
shift & enter, not just enter.

Cheers
JulieD

"dhodges00" wrote in message
...
I have 24 columns. In columns 25 and 26, I want the sum totals of every
other
column to its left. In other words, column 25 would show the sum of
columns,
1,3,5,7,... and column 26 the sum of columns 2,4,6,8,....

I have manually entered the formula =sum(a1+c1+e1+.....x1). Is there an
easier way?

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Manuel Excel Discussion (Misc queries) 1 January 13th 05 04:52 PM jbsand1001 Excel Worksheet Functions 2 January 7th 05 09:36 PM MA Excel Worksheet Functions 1 January 7th 05 05:06 PM bvi Excel Worksheet Functions 3 December 23rd 04 07:14 PM Carlsbad Excel Worksheet Functions 0 October 28th 04 01:19 AM

All times are GMT +1. The time now is 12:10 PM. Copyright ©2004-2020 ExcelBanter.