Excel
 

What is the formula to know how many times are repeated a number?

Excel
 

Hi Carlos,

If you just want to identify how many times a certain value occurs in a
range then =countif(range,criteria) will get the answer

e.g. =Countif(A1:a10,75)

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=512271