ExcelBanter - How do I count several non-numerical values in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I count several non-numerical values in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/43768-how-do-i-count-several-non-numerical-values-excel.html)

Yuccaman

How do I count several non-numerical values in Excel?

I am trying to create a formula to add the number of \ and L in a row. It
seems simple but COUNT does not seem to want to do it. Help please!!!

CLR

=COUNTIF(A4:F4,"\")+COUNTIF(A4:F4,"L")

Change the ranges to suit your situation...........

Vaya con Dios,
Chuck, CABGx3

"Yuccaman" wrote in message
...
I am trying to create a formula to add the number of \ and L in a row. It
seems simple but COUNT does not seem to want to do it. Help please!!!

All times are GMT +1. The time now is 06:30 PM.