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