=countif(a:a,1)
will count the 1's

=countif(a:a,6)
will count the 6's

=countif(a:a,"somewordhere")
will count the somewordhere's

James Odom wrote:

I have a list of numbers (1,2,4,5,2,1,2,3,4,) in a column and i would like a
function to list them out as a total (1 = x, 2 = x, 3=x, 4=x) i did this one
time long ago and i can not remember how. Could someone assist me.

I also need one for words listed as the request above.

--

Dave Peterson