You can add much more than that, if indded you are using non adjacent cells
like

=SUM(A1,B3,C4 etc)

then you can use 30, then another 30 like

=SUM((1,3,5,...........,30),next_30 etc))

just use extra parenthesis or select 30 cell and name them batch1, select
next 30 and name then batch2 etc

Regards,

Peo Sjoblom

"Robin" wrote:

I am not able to add more than 30 cells in a column and need to add at least
70 - what do I do?