Yes there is. It is an array formula. Example
=AVERAGE(IF($H$3:$H$23=C11,$K$3:$K$23)
--
Don Guillett
SalesAid Software

"Knoxi" wrote in message
...
There is no such function as this


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-