How to count multiple text values in a range

[ssedlace]

I am trying to count how many times any of the following text values show up in a cell range.

Cell range - A5:AG5
text I am trying to count:
LQD
LQD2
LQD3

I have tried this formula but it is returning a blank cell.
=COUNTIF(V5:AG5,"LQD")+COUNTIF(V5:AG5,"LQD2")+COUNTIF(V5:AG5,"LQD3")

What am I doing wrong?

 

[Andrew Poulsom]

Welcome to mrExcel.

If the range is A5:AG5 why V5:AG5 in your formula?

 

[ssedlace]

Sorry, my type error. The range is V5:AG5

 

[Andrew Poulsom]

Your formula worked for me. When you say it returns a blank cell, what is the number format of that cell? The formula can only return a number (zero or above).

 

[ssedlace]

It is actually showing FALSE in the cell. when on my report it should report 10 occurances of those values.

 

[Andrew Poulsom]

It's not possible for that formula to return FALSE. It can only return a number.

 

[ssedlace]

Okay, then is there a formula that would allow me to say count any cell in the range V5:AG5 that has a value that starts with an L ?