R
Robin
I am not able to add more than 30 cells in a column and need to add at least
70 - what do I do?
70 - what do I do?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
will this work for you?
=sum(a1:a100000)
=sum(a1:a100000)
P
Peo Sjoblom
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
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
A
Art
Peo,
I was browsing through and saw your answer -- I did not know there was a 30
item limit. I tried it and found something else. If I do this:
=sum((a1,a2, etc. )) it seems to work for more than 30 items. That is, just
doubling the parentheses. I did this accidentally while following your
suggestion. Do you know if this will generally work?
Art
I was browsing through and saw your answer -- I did not know there was a 30
item limit. I tried it and found something else. If I do this:
=sum((a1,a2, etc. )) it seems to work for more than 30 items. That is, just
doubling the parentheses. I did this accidentally while following your
suggestion. Do you know if this will generally work?
Art
P
Peo Sjoblom
Yes, that seems to work as well
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)