ExcelBanter - View Single Post

jmcclain

Thanks greatly...

"Don Guillett" wrote:

=sum(a1,a4)+sum(a7,a9)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jmcclain" wrote in message
...
I am trying to sum more than 30 cells (non sequential). I have used the
following for any # of cells less than 30

=sum(a1,a4,a7,a9)

However, how can I handle this when I have more than 30 cells to total?

The spreadsheet is 15 years old and would be almost impossible to modify.
Is there a different function that can accomplish this goal?

Thanks

Jon