Is there an equivalent to sumif for average, i.e. averageif? If not, do
you know of any simple solutions?

I was thinking of creating a separate row to hold the relevant data
subset. Using an if statement, I would blank out ("") all the values
from the original data set not needed for the average calculation. And
then just calculate the average on the new data subset. I figured,
however, that there was probably a more desirable way to do this. Any
help is appreciated.


--
name
------------------------------------------------------------------------
name's Profile: http://www.excelforum.com/member.php...o&userid=34115
View this thread: http://www.excelforum.com/showthread...hreadid=538916