counting from a conditional format (1 Viewer)

[whhaatt]

Hi all

Just waning to know, if i have a set number of values and i want to know how many times they have appeared, how would i display this

eg
3
3
5
23
5
6

I am wanting to know if how many times 3 has appeared,

Answer is twice or 2

How would I go about doing this in the spreadsheet


Thankyou In Advance

 

[whhaatt]

Solved

ITS OK I figured it out

=COUNTIF(C9:C400,"3")

this counts how many times 3 appears in a column

=COUNTIF(C9:C400,"accept")

this counts how many times the word "accept" appears in a column

Thankyou

 

[shades]

Actually, if they are true numbers, then you don't need the quote around it>

=COUNTIF(C9:C400,3)

For true text, you need the quotes:

=COUNTIF(C9:C400,"accept")
________
Fine-x