Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |