Is this the case that you know of?

No. See my reply in another branch of this thread.

They are actually every 6th cell

Tell us the first few cells that need to be averaged. We'll be able to see
the pattern and figure it out. For example, average cells A2, A8, A14, A20.


--
Biff
Microsoft Excel MVP


"Karen" wrote in message
...
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).