Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |