B
Becky
I need the function that will add 3 cells out of 5 cells
by dropping the highest and the lowest values. For
instance if the five cells contained:
5.5 6.5 6.5 5.5 5.5
I need to drop one 6.5(high) and one 5.5(low) and come up
with a sum of 17.5. Any help appreciated.
Becky
by dropping the highest and the lowest values. For
instance if the five cells contained:
5.5 6.5 6.5 5.5 5.5
I need to drop one 6.5(high) and one 5.5(low) and come up
with a sum of 17.5. Any help appreciated.
Becky