Thread
:
Average less MIN formula help needed
View Single Post
#
5
Posted to microsoft.public.excel.misc
MartinW
external usenet poster
Posts: 860
Average less MIN formula help needed
Hmmm sounds like homework!
Look at these formulas
=SUM(A1:A4)-MIN(A1:A4)
and
=COUNT(A1:A4)-1
Now see if you can put them together to come up
with an average.
HTH
Martin
Reply With Quote
MartinW
View Public Profile
Find all posts by MartinW