Count number of values equal to MAX of a column

I'm trying to find the number of values in a column that equal the maximum value of that column.

If it didn't return a -0-, this is what I would like to do:

=COUNTIF(B3:B723, "=MAX(B3:B723)")

If the column contained: (1, 2, 3, 4, 5, 5, 5, 2),
I would like (3) returned.

=COUNTIF(B3:B723,MAX(B3:B723))

HTH
--
AP

"dauclair" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> I'm trying to find the number of values in a column that equal the
> maximum value of that column.
>
> If it didn't return a -0-, this is what I would like to do:
>
> =COUNTIF(B3:B723, "=MAX(B3:B723)")
>
> If the column contained: (1, 2, 3, 4, 5, 5, 5, 2),
> I would like (3) returned.
>
>
> --
> dauclair
> ------------------------------------------------------------------------
> dauclair's Profile:
> http://www.excelforum.com/member.php...o&userid=34852
> View this thread: http://www.excelforum.com/showthread...hreadid=546688
>