My first guess is that you have calculation set to manual.

tools|options|calculation tab.

And the 30 arguments isn't a problem for your formula. It refers to things
like:

=count(a1,a2,a3,b1,b2,b3,....)

=count(c6:c36) is just using one argument.

===
My second guess is that some of your numbers aren't really numbers--they're text
masquerading as numbers.

What do you get when you put =count(c6:c36) in another cell?
what do you get when you put =counta(c6:c36) in another cell?

If you think all your values are numbers, do these formulas match?



S L Pace wrote:

I'm trying to create a estimated sales pace for the month at my restaurant
from a chart that has our daily sales in it.

The current chart has the following formula "=(C38/COUNT(C6:C36))*31" in
cell C42. This formula takes cell C38 which is the TOTAL SALES for the month
using the formula "=SUM(C6:C36)". This formula takes the DAILY SALES from C6
to C36 and obviously adds them up. Our daily sales vary greatly, as on the
weekends we do double to triple our weekday business.

Right now the formula is giving us the same number as our sales total for
the month which from prior experience is probably off by about 27 thousand
dollars.

According to what I can tell the COUNT function allows 1 to 30 arguments is
this what is causing the problem? And how do I create a solution?

Softwa Excel 2000
O/S: Windows 2000

--

Dave Peterson