ExcelBanter - AVERAGEIF problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - AVERAGEIF problem (https://www.excelbanter.com/excel-worksheet-functions/8555-re-averageif-problem.html)

Knoxi

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/ =-

Don Guillett

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/ =-

All times are GMT +1. The time now is 04:26 AM.