DMax criteria is not working

[Kevin Hogan]

I am trying to use the DMax function and I am using the
example in the help file for using an equation for the
criteria. ie. =C7>average($c$7:$c$10). I cannot get this
example to work. Am I doing something wrong?
Kevin.

 

[Peo Sjoblom]

How are you trying to use the dmax function using this criteria?

Here are some example based on the help

=DCOUNT(A4:E10,"Age",K1:K2)

where K1 would be blank and K2 hold

=C5>AVERAGE($C$5:$C$10)

would return 3


=DMAX(A4:E10,"Age",K1:K2)

would return the greatest value greater than average which would be 20

change the formula to

=C5<AVERAGE($C$5:$C$10)

and it would return greatest value less than average (12)