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).