Counting Three Different Words In One Column

  • Thread starter Thread starter swmasson
  • Start date Start date
S

swmasson

H ithere,

Can someone please help me? I have a column which can only have
option (due to validation), these are:-
New
Overdue
Updated
Closed


I would like to count the number of times each one has been entered.
Each count would be in a different cell on a different worksheet.
have tried searching this forum and found answers similar to what i'
looking for but i could not get any of them to work for some reason?

Thanks very much for your time.

Swmasso
 
Hi

you need to use the countif function for this
so if your range is on sheet 1 A1:A10
then on sheet2 in cell
A1 use
=COUNTIF(Sheet1!A1:A10,"New")
etc

Let us know how you go.

Cheers
JulieD
 
Hi there again,

I managed to figure out after searching the forum a bit longer, ver
easy -


=COUNTIF(J:J,"Updated")


And so on..............
 
Hi

glad you figured it, however, if you're performing the countif in another
sheet from where the data is you need to include the sheet name in front of
the range name
e.g.
=COUNTIF(Sheet1!J:J,"Updated")

Cheers
JulieD
 
Back
Top