MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula to Average more than 30 arguments in Excel 97?


Posted by Mario on December 28, 2001 1:25 PM

I have 36 fields in an Excel database I created and wish to display an average of these numbers in another field. Excel 97 only allows 30 arguments to be averaged. What is the easiest formula to use?


Posted by IML on December 28, 2001 1:43 PM

silly question

I assume these are non adjacent rows?
For example
=AVERAGE(A1:A30)
is considered just one argument.

Alterntivelys you could do
=(sum(30 argument)+sum(6 arguments))/(count(30 arg)+ count(30 arg))