Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 2 down vote favorite

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

2 Answers

up vote 4 down vote accepted

Use COUNTIF.

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
up vote 2 down vote

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.