tally of conditional formatting that is word-based

Jennifer E Brown 20 Reputation points
2024-10-18T14:50:46.1866667+00:00

I'm trying to tally a list where the contents of the cells are words not numbers. I want a total count of just 'yesses' and disregard the 'nos'. Guidance please?

Thank you.

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

Accepted answer
  1. Jiajing Hua 18,065 Reputation points Moderator
    2024-10-21T08:17:32.9533333+00:00

    Hi @Jennifer E Brown

    Wildcards can be used, like the formula =COUNTIF(A1:A4,"*yesses*").

    User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Viorel 122.6K Reputation points
    2024-10-18T18:17:49.15+00:00

    Try a formula like this: =COUNTIF(A1:A10,"yes"). Specify the actual range, and use ; instead of , if required.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.