Remember Me?

#1
January 12th 05, 05:13 PM
 dhodges00 Posts: n/a

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?

#2
January 12th 05, 05:20 PM
 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?

#3
January 12th 05, 05:29 PM

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?

#4
January 12th 05, 05:46 PM
 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?

 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.