HELP!

ALISHA · Mar 5, 2004

I have a colunm of numbers and I would like to have a cell
display how many times the number 5 was in the colunm.
thanks!

Frank Kabel · Mar 5, 2004

Hi
try
=COUNTIF(A1:A1000,5)

Guest · Mar 5, 2004

thanks! you are the man!

-----Original Message-----
Hi
try
=COUNTIF(A1:A1000,5)

--
Regards
Frank Kabel
Frankfurt, Germany

.