RE: AVERAGEIF problem

There is no such function as this


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

Yes there is. It is an array formula. Example
=AVERAGE(IF($H$3:$H$23=C11,$K$3:$K$23)
--
Don Guillett
SalesAid Software
donaldb@281.com
"Knoxi" <gk.grabit@ntlworld.com> wrote in message
news:CKWBd.304$JM.254@newsfe1-gui.ntli.net...
> There is no such function as this
>
>
> --------------= Posted using GrabIt =----------------
> ------= Binary Usenet downloading made easy =---------
> -= Get GrabIt for free from http://www.shemes.com/ =-
>