Array Formula Question - Urgent, please

[Sandi Rush]

Hi all:

I have an array formula question. Following is my data
layout:

Column A,D,G - Name for account exec.
Column B,E,H - January,February,March sales results
Column C,F,I - Blank

Billy Fisher is a account exec. at our firm, His sales
results are posted in a different row for each month,
based on rank.

In table below data, I list account execs in alpha order,
and would like to calculate average for all months for
each account exec.

I have entered the following as an array formula in a cell
corresponding to the table

=average(if(a5:a13,d5:d13,g5:g13="Billy
Fisher",b5:B13,e5:e13,h5:h13)

When I array enter it,I get "error in my formula" message,
and it highlights the D13. What am I doing wrong?


Thanks in advance.....

Sandi

 

[Rojee]

Try to use iserror insert it on your formula

 

[Don]

Sandi,

Try:

=AVERAGE(IF(A5:A13=A1,B5:B13),IF(D513=A1,E5:E13),IF(G5:G13=A1,H5:H13))

entered as array formula