Average if

[OzzyJim]

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

 

[Gary Keramidas]

you can try sumif / countif

 

[Jacob Skaria]

Try the below (without the FALSE condition)

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