A ALISHA Mar 5, 2004 #1 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!
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!
G Guest Mar 5, 2004 #3 thanks! you are the man! -----Original Message----- Hi try =COUNTIF(A1:A1000,5) -- Regards Frank Kabel Frankfurt, Germany . Click to expand...
thanks! you are the man! -----Original Message----- Hi try =COUNTIF(A1:A1000,5) -- Regards Frank Kabel Frankfurt, Germany . Click to expand...
