Counting occurances in a column

[booge]

New to the forum and more complicated functions in Excel, and can't seem to locate the proper help I need; hope someone can point me in the right direction.

I have a few ranges of information that I need to count based on the last letter in a cell. I have figured out how to use =COUNTIF for a single range if the entry is a single letter; however, the information I am dealing with is much longer, and in three or four different areas. I figure I will have to use an =RIGHT function, but do not know the proper syntax to insert it into a =COUNTIF, nor do I know if the =COUNTIF will accept multiple ranges.

Thanks for any help you all can provide.

[booge]

So, this is either really easy, or really hard... I believe I have figured out how to string together COUNTIF functions with the "+" operator. Now the situation lies in the recognition of the rightmost character in the cell, and get a count based off of that.

Thanks to anyone who can help!

[AlfD]

Hi!

Yes: you can add the results for the separate areas.

Try this "wildcard" method to get the number in a column, C1:C100, say:

=countif(C1:C100,"*p")

where "p" is the character you want to find at the end of the cell's contents.

Alf

[booge]

AlfD, thanks for the alternative method for the last letter count; it worked like a charm and everything's looking good. I do appreciate the help, greatly.