Try the below (without the FALSE condition)

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

--
Jacob


"OzzyJim" wrote:

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