General discussion

Locked

Excel: count cells in which text appears

By esrfalco ·
I have two columns of data. The second column has various text strings, and I want to count the number of cells in which a certain text appears. Some cells may contain "Yes, I'll attend," or "Yes, I'll be there," and I want to count how many cells have the word "Yes" in them. COUNT and COUNTIF look for precise matches. Is there any way I can count based on a partial match?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel: count cells in which text appears

by mbarker734 In reply to Excel: count cells in whi ...

COUNTIF(A1:A5, "*Yes*")

The above will provide you with all the combinations of yes in the range. Careful though as Yesterday will be counted as well.

Good luck,

Mark

Collapse -

Excel: count cells in which text appears

by esrfalco In reply to Excel: count cells in whi ...

Poster rated this answer

Collapse -

Excel: count cells in which text appears

by esrfalco In reply to Excel: count cells in whi ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums