Also note that next version of excel will have an averageif function

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Ardus Petus" wrote in message
...
Try SUMIF/COUNTIF

HTH
--
AP

"rudy" a écrit dans le
message de ...

Anyone know if there is averageif type of function similar to sumif?

Thanks.


--
rudy
------------------------------------------------------------------------
rudy's Profile:
http://www.excelforum.com/member.php...o&userid=33911
View this thread:
http://www.excelforum.com/showthread...hreadid=536854