Counting Number of Text Entries in EXCEL

[funkylad20]

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","")))

[New Judge]

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.

[funkylad20]

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