Adding different numbers
=COUNTIF(A1:A24,1)
=COUNTIF(A1:A24,2)
=COUNTIF(A1:A24,3)
--
David Biddulph
"jaywizz" wrote in message
...
Sorry just a follow up question. If I have a column filled with 1's, 2's
and
3's how can I count each number i.e. there are seven 1's, six 2's and
eleven
3's?
|