Excel Function

[James Odom]

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]

=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

 

[Sandy Mann]

Do you mean:

=COUNTIF(A1:A9,1)

=COUNTIF(A1:A9,2)

etc.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Mike H]

Another thought, put this in a cell and drag down

=COUNTIF(A:A,ROW(A1))&" "&ROW(A1)&" s"

Mike