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 :eek:

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 :rolleyes:


Thankyou In Advance

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

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")