Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a column in a spreadsheet which lists the status of particular rows - the statuses are text strings like "accepted" "rejected" and so on.

Is there any formula I can use to count the number of times each status occurs in a given column?

share|improve this question
up vote 4 down vote accepted


Assuming you want to count "Accepted" in cells A1:A30:

=COUNTIF(A1:A30, "=Accepted")

share|improve this answer
Thank you very much I'm having some trouble doing this cross workbook, for some reason ='Backlog'!COUNTIF(J1:J3000, "=Accepted") does not seem to work – toomanyairmiles Aug 11 '10 at 21:31
and then I thought about it a bit more and realised that =COUNTIF('Backlog'!J1:J3000, "=Accepted") was what I was looking for! – toomanyairmiles Aug 11 '10 at 21:33
Great! Let me know if you have more trouble with it. – JNK Aug 11 '10 at 21:45

You could use a pivot table. Put the status field in the row area and some other field in the data area. If necessary, change the summary function to 'Count Of' for the data field. That will give you a count for each status (and blanks).

share|improve this answer
Thank you, if I could have accepted both answers I would have – toomanyairmiles Aug 11 '10 at 21:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .