Mon, 7 May 2007 20:58:01 -0700 from Caribbrz
:
Can someone please help me? I am doing a grade book and have 4 test scores
say in A1, A2, A3, and A4. I want to get the average score but dropping the
lowest test score first and giving equal weight to the remaining 3 test
scores. Can someone help me with this, please?

=(sum(A1:A4)-min(A1:A4))/3

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/