ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not able to add more than 30 cells in a column and need to add at least
70 - what do I do?
 
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
 
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trailing 30 days sum calculation with excel 1
how can i have more than 30 arguements in a SUM 6
SUM & Average Formula Problem 5
Adding Time in Excel - Frustating experience!! 5
Rounding Effecting Sum 2
Calculating Average 2
How to create a bubble chart with more than 2 variables 0
Summing 2 columns cells into a 3rd colums cells 1

Back
Top