They are actually every 6th cell and have a formula in them adding the five
day total of phone calls for those five days so there is a formula in this
particular cell. It tells me I have chosen too many arguments for this
function. So, it looks like I can average an unlimited number of simple cells
(just a number, no formulas) but if there is a formula inside it, it will be
limited to 30 of those cells. Is this the case that you know of?

"Duke Carey" wrote:

Are you values in contiguous cells?

Are the values numeric, i.e., are some of them text values that LOOK like
numbers?



"Karen" wrote:

Ok, I'll try that John, thanks. It very well could be a formula issue.

"John Bundy" wrote:

I just averaged 50k of them so that is not the issue. I would make sure none
are stored as text. next step is to average the first 2, then 3, 4 etc til
you find the problem cell. More than likely a format cells will resolve your
issue.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Karen" wrote:

Does anyone know if there is a limit to the number of cells you can use in an
average formula?
I'm trying to build an average for weekly number of phone calls for each
week so there should be about 52 cells to get an average from(one for each
week, save the holiday weeks).