The limit you are referring to is the number of individual arguments the
function can accept....not the number of cells referenced.

Example:
In this formula: =AVERAGE(A1:A1000,C1:C1000)
there are 2 arguments: A1:A1000 and C1:C1000

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Dave F" wrote:

I just used the function average: =AVERAGE(D2:D232) and then recalled that
AVERAGE can only accept thirty numbers.

So, I did =SUM(D2:232)/COUNT(D2:232) and that returned the same calculation
as AVERAGE(D2:D232).

What gives?
--
Brevity is the soul of wit.