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

.

vlookup	1	Jun 15, 2009
Matching data from one worksheet to another.	3	Sep 6, 2007
If I have a colunm of numbers, can I format to highlite the smalle	12	Oct 30, 2006
putting symbols	2	Jul 7, 2006
sum of check boxes that have been checked	2	Sep 3, 2009
Editing in excel	2	Oct 26, 2008
I have columns labeled as numbers instead alpha why?	2	Sep 26, 2008
A fromula to pick up nontext in cell	2	Dec 9, 2005

Ask a Question