SOLVED

New Contributor

# Counting Values non-numerical in rows

Hi! So I am fairly new to excel and I am working on a project in which the only data we really use are single alphabetical letters such as "R" and "W". I need to know the amount of times that these letters occur in each row in order to calculate averages.

Basically, I am inquiring if there is a way to view the number of times these certain letters occur per row in order to easier calculate these averages without having to manually go through and count the number of times a letter occurs in a row. Any and all help will be appreciated as this project would require me to manually go through around 200 rows! Thanks in advance!

5 Replies

# Re: Counting Values non-numerical in rows

- Do you want to count ALL non-numeric values in each row or only those = R or = W?
- If R or W only, do you want 2 separate counts or the total of both?

# Re: Counting Values non-numerical in rows

Hi! Only those that = R or W, and 2 separate counts
best response confirmed by JennaThornton (New Contributor)
Solution

# Re: Counting Values non-numerical in rows

Hi again @JennaThornton

See an example in the attached workbook. If you have challenge adapting it to your actual scenario please attach a representative workbook with a couple of rows to your next reply

Thanks

# Re: Counting Values non-numerical in rows

@L z. This is perfect!! Thank you so so much!

# Re: Counting Values non-numerical in rows

You're welcome. Glad this works as expected
Thanks for posting back & Nice day...