get the sum of 31 cells in a row

[stoey]

hi guys,

just a quick question:

how do you get the sum of 31 cells in a row? currently this doesn't work:

=SUM(H17,M17,R17,W17,AB17,AG17,AL17,AQ17,AV17,BA17,BF17,BK17,BP17,BU17,BZ17,CE17,CJ17,CO17,CT17,CY17,DD17,DI17,DN17,DS17,DX17,EC17,EH17,EM17,ER17,EW17,FB17)

thanks in advance

[Allseasons]

Add + between each cell

[JOHN H. DAVIS]

This may give you some ideas.

http://stackoverflow.com/questions/1...ction-in-excel