Forum Discussion

Copper Contributor

Jul 22, 2021

Solved

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 l...

excel

Lorenzo
Jul 22, 2021
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
XL_Countif_Jenna.xlsx17 KB

JennaThornton

Copper Contributor

Jul 22, 2021

Hi! Only those that = R or W, and 2 separate counts

Lorenzo

Silver Contributor

Jul 22, 2021

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

XL_Countif_Jenna.xlsx17 KB

JennaThornton
Copper Contributor
Jul 22, 2021
Lorenzo This is perfect!! Thank you so so much!
- Lorenzo
  Silver Contributor
  Jul 22, 2021
  You're welcome. Glad this works as expected
  Thanks for posting back & Nice day...