Use of arrays
 

I believe you're looking for AVERAGE(IF(...)) entered with CTRL+SHIFT+ENTER??

Does that refresh your memory?

Dave
--
Brevity is the soul of wit.


"DKS" wrote:

Hi,

I used to do have this kind of worksheet function (feature) a few years ago
but since then due to non-usage I have forgotten how to do it.

Basically I have a 2 column based spreadsheet. First column (column A)
contains a code (text), let us say:

A
B
C
....

There can be duplicates.

Second column (column B) contains a whole number. Once again can contain
duplicates.

In cell C1, I would give one of the valid text-codes that is available in
column A. Let us say that I type the code "C".

I would like a formula in cell D1 that gives me the average value (using
average function) of column B for all cells where in column A we find the
code "C". I believe this is doable with the array function (curly brackets)
but as mentioned at the start I have forgotten the technique.

all help appreciated.