calculate averages
Thanks Bob, I will give it a whirl
Dan
"Bob Phillips" wrote:
=AVERAGE(IF(A1:A10<MIN(A1:A10),A1:A10))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"inspiredtoo" wrote in message
...
How can I calculate averages automatically subtracting the lowest number
in a
range?
I was told to use the SUM, MIN and Count function
Thanks
|