Lookup text return average %

[dunmore83]

Hi,

I need to search cells L5:L35 for the text containing "YES" & return the value as a percentage over the number of cells in the range.

Thanks so much for your help!

 

[mrmmickle1]

=COUNTIF(L5:L35, "yes")/COUNTA(L5:L35)

Try using the above formula and then formatting the cell to %

-Matt

 

[Robert Mika]

Are there any empty cells in your range?

 

[dunmore83]

Yes.... some have a "-" & some have "NO".

Thanks

 

[Robert Mika]

Yes.... some have a "-" & some have "NO".

Thanks

Not sure if by "-" you mean empty or litellary "-",
But COUNTA will count only not empty cells.
You may need to add COUNTBLANK or use
=COUNTIF(L5:L35, "yes")/ROWS(L5:L35)

Format as %

 

[dunmore83]

I literally mean "-". Thanks

 

[Robert Mika]

So the formula posted by mrmmickle1 should give you the result.
Is that correct?

 

[mrmmickle1]

Robert,

Thanks as well. Now I know a little bit more the next time around for a different situation. You're the man!