"Dave Peterson" wrote in message
...
The limit is 1024 (when in R1C1 reference style).

You could use:

=sum(sum(a1,b1),sum(e1,g1),sum(q1,v1)


A little more simply with

=SUM((a1,b1,c1, etc),(e1,g1, etc))

that is group them within the SUM itself