AVERAGE can only accept thirty numbers.

No, Average can accept up to 30 arguments:

D2:D232

is just one argument.

=AVERAGE(A1,A2,A3,A4,A5)

That has 5 arguments

=AVERAGE(A1:A100,AA1:AA100)

That has 2 arguments

=AVERAGE((A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,
A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,A2 5,
A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36))

That has 1 argument

Biff

"Dave F" wrote in message
...
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.