Donate SIGN UP

Counting Number of Text Entries in EXCEL

Avatar Image
funkylad20 | 11:26 Thu 26th Mar 2009 | Computers
2 Answers
I have a long list of data, each with a choice of 3 outcomes attached (e.g. Accepted, Rejected, Withdrawn)

Does anybody know the foruma to make it count the data entries in the spreadsheet. I would like a numeric summary of how may have been Accepted, Rejected, Withdrawn. I have got this so far but have come up with #VALUE! error messages...

=SUM(LEN(I8:I442)-LEN(SUBSTITUTE(I8:I442,"Accepted","")))
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Am I missing something or are you making this unnecessarily complex?

Let�s say your data (that is the �Accepted�, �Rejected� and �Withdrawn� entries) are in the range A1:A100.

How about (in, say, cell B1):

=COUNTIF(A1:A100,"Accepted")

In B2:

=COUNTIF(A1:A100,"Rejected")

In B3:

=COUNTIF(A1:A100,"Withdrawn")

This will give you, in cells B1 to B3, the numbers of records with each result.


Question Author
Yup, many thanks. I just googled and got my formula, overcomplicated as it is!

1 to 2 of 2rss feed

Do you know the answer?

Counting Number of Text Entries in EXCEL

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.