Share via

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
Answer accepted by question author
  1. Jiajing Hua 18,140 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
Most helpful Newest Oldest
  1. Viorel 125.7K 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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.