ExcelBanter - Average if

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Average if (https://www.excelbanter.com/excel-discussion-misc-queries/256623-average-if.html)

OzzyJim

Average if

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[_3_]

Average if

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

Jacob Skaria

Average if

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

All times are GMT +1. The time now is 07:42 AM.