Summing columns

M

mahadevan.swamy

Is there a better and a shorter formula than the one below. I want to
make sure I didnt miss any column when I summed them up.

=SUM(C6,E6,G6,I6,K6,M6,O6,Q6,S6,U6,W6,Y6,AA6,AC6,AE6,AG6,AI6,AK6,AM6,AO6,AQ6,AS6,AU6,AW6,AY6,BA6,BC6,BE6,BG6,BI6)+SUM(BK6,BM6,BO6,BQ6,BS6,BU6,BW6,BY6,CA6,CC6,CE6,CG6,CI6,CK6,CM6,CO6,CQ6,CS6,CU6,CW6,CY6,DA6,DC6,DE6,DG6,DI6,DK6,DM6,DO6,DQ6)+SUM(DS6,DU6,DW6,DY6,EA6,EC6,EE6,EG6,EI6,EK6,EM6,EO6,EQ6,ES6,EU6,EW6,EY6,FA6,FC6,FE6,FG6,FI6,FK6,FM6,FO6,FQ6,FS6,FU6,FW6,FY6)+SUM(GA6,GC6,GE6,GG6,GI6,GK6,GM6,GO6,GQ6,GS6,GU6,GW6,GY6,HA6,HC6,HE6,HG6,HI6)

As you can see the columns are skipped and selected.

Thanks

Swamy
 
T

Toppers

Try:

=SUM(IF(MOD(COLUMN(C6:HI6),2)=0,0,C6:HI6))

(I haven't checked but assume they are contiguous alternate columns!)

enter with Ctrl+Shift+Enter
 
Top