Hi,

There are several solutions but due to the lack of data this may not be the
best but it may help:-

=SUM(SUM(Ref1,Ref2,up to 30),SUM(Ref31,Ref32,up to another
30))/SUM(COUNT(Ref1,Ref2,...),COUNT(Ref31,Ref32,...))

You can have up to 30 cell references in each sum and count

Mike

"pjr" wrote:

Is it possible to have more than thirty arguments in a single average
function? The arguments are not contiguous, so i can't just make them into
data points...

What should I do?