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.


--
dauclair
------------------------------------------------------------------------
dauclair's Profile: http://www.excelforum.com/member.php...o&userid=34852
View this thread: http://www.excelforum.com/showthread...hreadid=546688

Count number of values equal to MAX of a column
 

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

HTH
--
AP

"dauclair" a écrit
dans le message de news:
...

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