Average, Min or Max Dependant on Criteria in Seperate Column

[nld]

Hi All

I am trying to AVE MIN and MAX values in a column based on what appears in another column.
The coding below is what I'm using but it either shows false or gives the answer but is outside the criteria. i.e. it's the column AVE MIN MAX rather than the criteria AVE MAX MIN.
Can anyone help
Thanks in advance
nld

Please Login or Register  to view this content.

[rylo]

Hi

how about (array entered)

=MIN(IF($E$13:$E$490>"",$G$13:$G$490,""))
=MAX(IF($E$13:$E$490>"",$G$13:$G$490,""))
=AVERAGE(IF($E$13:$E$490>"",$G$13:$G$490,""))

rylo