counting data in excel...

[randomlinh]

There's gotta be a way to do this... Say I have a column of data, values are either 1,2, or 3. I want to count the number of instances of each number. How could I manipulate count() to do this, or is there some other way to go about this?

Thanks

 

[wildwolf]

=countif(range, criteria)

ie:
A1-A3 = 1
A4-A7 = 2
A8-A9 = 3

A11-=COUNTIF(A1:A9,1) would yield 3
A12-=COUNTIF(A1:A9,2) would yield 4
A13-=COUNTIF(A1:A9,3) would yield 2

That what you wanted?

 

[wildwolf]

Ahh, come on man, lemme know if I helped a Lifer for a change. 🙂

 

[randomlinh]

you did, you did! i forgot about this... i ended up not needing it for what i was doing.. but need it again... heh