Try instead, something like:
=3DSUMPRODUCT(--(MOD(COLUMN(A1:Z1),2)=3D1),A1:Z1)

or for all 256 cols A to IV
(i.e. the entire row: A1:IV1)
=3DSUMPRODUCT(--(MOD(COLUMN(1:1),2)=3D1),1:1)

--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----
Kanga 85 wrote:
I need to sum alternate columns over a very large number of columns.
Is
there an easy way to do this? Sum(A1+C1+E1+G1 .... ) seems to bomb
out
after about 32 entries and I need more than this.
Any Help,
Thanks,