I've responded further to you in your earlier thread, suggesting the use of
AVERAGE(IF(...)) array formulas. Take a look there.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Penny" wrote in message
...
I should have been more specific. I thought you were going to use the
average function and then I was hoping to figure out the rest. I also
need
to be able to compute the standard deviations, minimum, and maximum.

Thanks, Penny