| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM & Average Formula Problem
I want to sum up different cells around 40 in a single worksheet but they are
in different rows and columns and I can't select a range to add them up but whenever I try to give different cell locations separating them by comma, it stops after 30 cells. Is there any way to sum or get average of more than 30 numbers in a single worksheet ?????????? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM & Average Formula Problem
Do it like this:
=SUM(list of up to 30 cells) + SUM(list of another 30 cells) + etc. To get an average you can take the sum from above and divide it by the COUNT of the number of cells. Hope this helps. Pete On Aug 15, 7:48*am, Miki wrote: I want to sum up different cells around 40 in a single worksheet but they are in different rows and columns and I can't select a range to add them up but whenever I try to give different cell locations separating them by comma, it stops after 30 cells. Is there any way to sum or get average of more than 30 numbers in a single worksheet ?????????? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM & Average Formula Problem
Or even just
=SUM((list of up to 30 cells),(list of another 30 cells),(etc...)) -- David Biddulph "Pete_UK" wrote in message ... Do it like this: =SUM(list of up to 30 cells) + SUM(list of another 30 cells) + etc. To get an average you can take the sum from above and divide it by the COUNT of the number of cells. Hope this helps. Pete On Aug 15, 7:48 am, Miki wrote: I want to sum up different cells around 40 in a single worksheet but they are in different rows and columns and I can't select a range to add them up but whenever I try to give different cell locations separating them by comma, it stops after 30 cells. Is there any way to sum or get average of more than 30 numbers in a single worksheet ?????????? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM & Average Formula Problem
Yes, of course, David - thanks.
Pete On Aug 15, 1:36*pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: Or even just =SUM((list of up to 30 cells),(list of another 30 cells),(etc...)) -- David Biddulph "Pete_UK" wrote in message ... Do it like this: =SUM(list of up to 30 cells) + SUM(list of another 30 cells) + etc. To get an average you can take the sum from above and divide it by the COUNT of the number of cells. Hope this helps. Pete On Aug 15, 7:48 am, Miki wrote: I want to sum up different cells around 40 in a single worksheet but they are in different rows and columns and I can't select a range to add them up but whenever I try to give different cell locations separating them by comma, it stops after 30 cells. Is there any way to sum or get average of more than 30 numbers in a single worksheet ??????????- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM & Average Formula Problem
Or even just:
=Sum((list of as many cells as needed)) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Or even just =SUM((list of up to 30 cells),(list of another 30 cells),(etc...)) -- David Biddulph "Pete_UK" wrote in message ... Do it like this: =SUM(list of up to 30 cells) + SUM(list of another 30 cells) + etc. To get an average you can take the sum from above and divide it by the COUNT of the number of cells. Hope this helps. Pete On Aug 15, 7:48 am, Miki wrote: I want to sum up different cells around 40 in a single worksheet but they are in different rows and columns and I can't select a range to add them up but whenever I try to give different cell locations separating them by comma, it stops after 30 cells. Is there any way to sum or get average of more than 30 numbers in a single worksheet ?????????? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM & Average Formula Problem
Thanx a ton ..........
It worked ........ "RagDyer" wrote: Or even just: =Sum((list of as many cells as needed)) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Or even just =SUM((list of up to 30 cells),(list of another 30 cells),(etc...)) -- David Biddulph "Pete_UK" wrote in message ... Do it like this: =SUM(list of up to 30 cells) + SUM(list of another 30 cells) + etc. To get an average you can take the sum from above and divide it by the COUNT of the number of cells. Hope this helps. Pete On Aug 15, 7:48 am, Miki wrote: I want to sum up different cells around 40 in a single worksheet but they are in different rows and columns and I can't select a range to add them up but whenever I try to give different cell locations separating them by comma, it stops after 30 cells. Is there any way to sum or get average of more than 30 numbers in a single worksheet ?????????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| Average Problem | Excel Worksheet Functions | |||
| Problem With An Average IF Formula | Excel Worksheet Functions | |||
| AVERAGE problem | Excel Worksheet Functions | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Hybrid Mode
