Thread: Calculate every second column

HI

I have a sheet where I have data in every second column that I want to sum.

I.e.

Row 1 contians data in column A, C, E, G.....etc. Of course I cn use the normal SUM function, but when I have over 30 column it`s not so elegant...

Any suggestion?

Thanks for any help

Elad
Norway

One way, an array formula so enter with ctrl+shift+enter

=sum(if(mod(column(a1:e1),2)<>0,a1:e1))

Works fine -thanks a lot!

elad
Norway