Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
I am trying to average 36 seperate values in 36 different cells but I keep
getting an error. Is there a limit on how many cells can be used in a function? If not, what am I doing wrong? If there is a limit, how do I get around this issue? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
What formula are you using?
I'm not aware of such a limit, however, if there were such a limit, the solution would be to split the range of cells to be averaged into to ranges, average each of those ranges, and then average the two averages. Dave -- Brevity is the soul of wit. "pingwin77" wrote: I am trying to average 36 seperate values in 36 different cells but I keep getting an error. Is there a limit on how many cells can be used in a function? If not, what am I doing wrong? If there is a limit, how do I get around this issue? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
hi Dave,
You should answer back in the Questioner's forum. Your answers are always good, but I need the questions too. Hope you will help me too to understand your posts. Thanks, Shail Dave F wrote: What formula are you using? I'm not aware of such a limit, however, if there were such a limit, the solution would be to split the range of cells to be averaged into to ranges, average each of those ranges, and then average the two averages. Dave -- Brevity is the soul of wit. "pingwin77" wrote: I am trying to average 36 seperate values in 36 different cells but I keep getting an error. Is there a limit on how many cells can be used in a function? If not, what am I doing wrong? If there is a limit, how do I get around this issue? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
On Wed, 6 Sep 2006 07:20:01 -0700, pingwin77
wrote: I am trying to average 36 seperate values in 36 different cells but I keep getting an error. Is there a limit on how many cells can be used in a function? If not, what am I doing wrong? If there is a limit, how do I get around this issue? From Excel Specifications: Arguments in a function 30 You "get around" it by referencing the cells with less than 30 arguments. For example: =AVERAGE(A1:A36) If the cells are non-contiguous, you may be able to group them or NAME the non-contiguous range, or use some kind of formula to refer to the non-contiguous range. Worst case scenario where neither of the above is applicable: =(A1+B4+C16+D92+.....) / 36 --ron |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
Note that the average of the averages of unequal ranges may not be the same
as the average of the whole range. e.g avgerage of 100 = 100, average of 1,1,1 = 1 average of averages is about 50, average of the four values is about 25. "Dave F" wrote in message ... What formula are you using? I'm not aware of such a limit, however, if there were such a limit, the solution would be to split the range of cells to be averaged into to ranges, average each of those ranges, and then average the two averages. Dave -- Brevity is the soul of wit. "pingwin77" wrote: I am trying to average 36 seperate values in 36 different cells but I keep getting an error. Is there a limit on how many cells can be used in a function? If not, what am I doing wrong? If there is a limit, how do I get around this issue? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
Hi Shail,
I'm not sure what you mean by the Questioner's Forum? -- Brevity is the soul of wit. "shail" wrote: hi Dave, You should answer back in the Questioner's forum. Your answers are always good, but I need the questions too. Hope you will help me too to understand your posts. Thanks, Shail Dave F wrote: What formula are you using? I'm not aware of such a limit, however, if there were such a limit, the solution would be to split the range of cells to be averaged into to ranges, average each of those ranges, and then average the two averages. Dave -- Brevity is the soul of wit. "pingwin77" wrote: I am trying to average 36 seperate values in 36 different cells but I keep getting an error. Is there a limit on how many cells can be used in a function? If not, what am I doing wrong? If there is a limit, how do I get around this issue? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
hi Dave,
Sorry to confuse you, but I just wanted if you can answer it back from where someone has asked you the question. So that anyone can read the question and your answer too. Thanks again Dave, Shail Dave F wrote: Hi Shail, I'm not sure what you mean by the Questioner's Forum? -- Brevity is the soul of wit. "shail" wrote: hi Dave, You should answer back in the Questioner's forum. Your answers are always good, but I need the questions too. Hope you will help me too to understand your posts. Thanks, Shail Dave F wrote: What formula are you using? I'm not aware of such a limit, however, if there were such a limit, the solution would be to split the range of cells to be averaged into to ranges, average each of those ranges, and then average the two averages. Dave -- Brevity is the soul of wit. "pingwin77" wrote: I am trying to average 36 seperate values in 36 different cells but I keep getting an error. Is there a limit on how many cells can be used in a function? If not, what am I doing wrong? If there is a limit, how do I get around this issue? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
Well, you have me really confused now, because I can just scroll down and see
the original question! Sorry, not sure why you can't see the original question??? Dave -- Brevity is the soul of wit. "shail" wrote: hi Dave, Sorry to confuse you, but I just wanted if you can answer it back from where someone has asked you the question. So that anyone can read the question and your answer too. Thanks again Dave, Shail Dave F wrote: Hi Shail, I'm not sure what you mean by the Questioner's Forum? -- Brevity is the soul of wit. "shail" wrote: hi Dave, You should answer back in the Questioner's forum. Your answers are always good, but I need the questions too. Hope you will help me too to understand your posts. Thanks, Shail Dave F wrote: What formula are you using? I'm not aware of such a limit, however, if there were such a limit, the solution would be to split the range of cells to be averaged into to ranges, average each of those ranges, and then average the two averages. Dave -- Brevity is the soul of wit. "pingwin77" wrote: I am trying to average 36 seperate values in 36 different cells but I keep getting an error. Is there a limit on how many cells can be used in a function? If not, what am I doing wrong? If there is a limit, how do I get around this issue? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
Right, but when the set of items is an even number, as in this case (36),
AVERAGE(A+B+C+D) = AVERAGE(AVERAGE(A+B),AVERAGE(C+D)) In the case of an uneven number of values, then the solution would be to sum up the range and divide by the count; i.e., =SUM(A1:A1001)/COUNT(A1:A1001). Dave -- Brevity is the soul of wit. "David Cox" wrote: Note that the average of the averages of unequal ranges may not be the same as the average of the whole range. e.g avgerage of 100 = 100, average of 1,1,1 = 1 average of averages is about 50, average of the four values is about 25. "Dave F" wrote in message ... What formula are you using? I'm not aware of such a limit, however, if there were such a limit, the solution would be to split the range of cells to be averaged into to ranges, average each of those ranges, and then average the two averages. Dave -- Brevity is the soul of wit. "pingwin77" wrote: I am trying to average 36 seperate values in 36 different cells but I keep getting an error. Is there a limit on how many cells can be used in a function? If not, what am I doing wrong? If there is a limit, how do I get around this issue? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
Is there some kind of pattern, like every other cell? Every 5th cell?
You can always use multiple range references: =AVERAGE((A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12, A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24, A25,A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36)) There can be up to 30 arguments but using multiple range references the above formula contains only 1 argument. Of course, you wouldn't need this for the sample range used because it's a contiguous range. This is only an example. Biff "pingwin77" wrote in message ... I am trying to average 36 seperate values in 36 different cells but I keep getting an error. Is there a limit on how many cells can be used in a function? If not, what am I doing wrong? If there is a limit, how do I get around this issue? |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
shail wrote...
Sorry to confuse you, but I just wanted if you can answer it back from where someone has asked you the question. So that anyone can read the question and your answer too. .... You're using Google Groups, but the OP posted through Microsoft's newsgroup web portal. Microsoft being Microsoft, few if any original postings through their web portal are ever pushed out to other NNTP (news) servers. However, Microsoft being Microsoft, responses are pushed out to other NNTP servers. This is just something you need to learn to live with when using Google Groups to read Microsoft newsgroups. Dave F was doing the right thing, and *was* responding in the same newsgroup as the OP. |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I average 36 values?
Thanks Harlan,
This might be too technical to understand, but I got Dave and the original question. Thanks again, Shail Harlan Grove wrote: shail wrote... Sorry to confuse you, but I just wanted if you can answer it back from where someone has asked you the question. So that anyone can read the question and your answer too. ... You're using Google Groups, but the OP posted through Microsoft's newsgroup web portal. Microsoft being Microsoft, few if any original postings through their web portal are ever pushed out to other NNTP (news) servers. However, Microsoft being Microsoft, responses are pushed out to other NNTP servers. This is just something you need to learn to live with when using Google Groups to read Microsoft newsgroups. Dave F was doing the right thing, and *was* responding in the same newsgroup as the OP. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Values / Multiple Worksheets | Excel Worksheet Functions | |||
Conditional math using AND, Average | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
How to average a column, but exclude zero AND negative values? | Excel Discussion (Misc queries) | |||
How do I average a formula without calculating zero values? | Excel Discussion (Misc queries) |