You have to give us some details! Like:

Post the *exact* formula
Tell us *exactly* what cell that formula is entered in
If any of the values being averaged are the results of formulas, we'd need
to know what those formulas look like and the *exact* location of those
formulas.

--
Biff
Microsoft Excel MVP


"AmandaCollins" wrote in message
...
As soon as I enter my information into the Function Arguments dialogue box
the formula result is correct but when i hit enter it says stuff about a
circular reference but i have done everythign it tells me to and my
teachers
cant figure it out either... Please help...