you can try sumif / countif
--


Gary Keramidas
Excel 2003


"OzzyJim" wrote in message
...
Hi All,

Am trying to get an average with the following

=AVERAGE(IF('Commercial Register'!N14:N2437="Repair",'Commercial
Register'!$AD$14:$AD$2437, 0))

So if results in column N meet "repair" criteria, it averages the results
in
column AD

No Joy even in an array format. Any ideas???

Cheers
Jim