help! I am entering a column of data into excel and I need to..

  • Thread starter Thread starter Diana
  • Start date Start date
D

Diana

help! I am entering a column of repetative data into
excel and I need to..count how many times they occur. I
have tried using sum and count features but they don't
count text. Is there a way to assign text a value of 1 so
they total or I can use autofilter to just show me the
specific data i want to count but I can't find a way to
total that either. help please I'm a beginner so please be
specific.

Thank you
 
Diana,

=COUNTIF(A:A,"Example")
will count all occurances of Example in column A (note
counts the number of cells that have exaclty Example
entered into them)

=COUNTIF(A1:A1000,"Example")
will count the same thing, but only in the range A1:A1000

Dan E
 
You could try using an If statement:

IF(cell reference=the repeating data, 1,0) then simply
sum the column and you should have the # you'd like. Is
that what you're looking for or am I being to basic?
 
Back
Top