Does a range of cells contain a letter?

**DarrylBurge** · 07-07-2014, 07:04 AM

I have a spreadsheet that monitors whether I have visted a learner in a given month.

I want to have a cell that displays "Yes" if I have visited the learner and entered a V in any of the 31 (July) cells in the row.

I have tried =IF(COUNTIF(g9:g31,"V")>0,"Yes","NO") with no success.

not sure if it i relevant, but the sheet I am using has been formatted as a Table (just to allow alternate light and dark rows).

TIA

**Special-K** · 07-07-2014, 07:18 AM

That formula looks fine to me.

Maybe it's not a "V" maybe it includes a space (though I doubt it)?

The way to test this is to find a cell that contains a "V" e.g. G9

and set another cell based on that value,e.g.

in A1
=(G9="V")

If you get TRUE it's a "V" if not that would indicate why you're not getting any results.

Might be best to post the spreadsheet (removing any sensitive date of course).

UPDATE: You mention "any of the cells in that row"
the range G9:G31 is a COLUMN not a row.

**romperstomper** · 07-07-2014, 08:21 AM

It's also not 31 cells.

**DarrylBurge** · 07-10-2014, 06:07 AM

My apologies, I had not changed the Formula, it should have read:

=IF(COUNTIF(g14:ak14,"V")>0,"Yes","NO")

Cells N14 and Q14 contain "V", but all that happens is the cell where the function is, it shows the function, almost as if the "Show Formula" button had been used.

Spreadsheet has been attached. TIA for any help.

Darryl