Count the times a number appears in a column

  • Thread starter Thread starter Paul R
  • Start date Start date
P

Paul R

I would to find out how I can lookup a column and count the number of times
a preticular number appears innthat column.

Thanks
Paul
 
=COUNTIF(A:A,1)

will count the times the number 1 appears in Col A
 
Countif works if you want to count the # of "1" in a range that contains
1,11,111 and return the value 1.

if not, you want to count times that a character (number) occured, look for
the recent message in this group called "counting text" started by "stavrou"
which contains a formula to count all occurences.
 
Paul,

Use the COUNTIF function

=COUNTIF(A1:A100,1)

where
A1:A100 is the range of numbers
and
1 is the particular number you are trying to count.

Regards,
Scott
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number times a value appears in a column beside it chronological 3
Count help 3
Calculate total by row number 4
Counting in columns 5
Count the times a value appears in a column based on another value 6
CountIf Functions 6
COUNTING "ERR" IN COLUMN 2
Counting Criteria in Cells in Multiple Ranges 4

Back
Top