2

I'm relatively new to Google sheets but I was hoping you could help me out.

Let's say I have the following information in a table:

Column A Column B
$14.99
$14.99 Yes
$12.99
$13.99 Yes
$14.99 Yes

I want to use COUNTIF to count the number of times column A has $14.99, BUT I only want to know if in those same results, Column B doesn't contain "Yes". (So in this case the total count should be 1)

Hopefully, that makes sense. Any idea which formula I should use?

1
  • You said your total count of instances where Col A contains $14.99 but Col B does not contain "Yes" is 2. I count 1. So it's unclear if you made an error in your count or in your explanation. Please double-check and adjust your post accordingly.
    – Erik Tyler
    Feb 2, 2022 at 19:14

1 Answer 1

1

See my comment to your original post. Assuming that your posted count of matches was off and that it should be 1, this formula will produce the correct count:

=COUNTIFS(A2:A,14.99,B2:B,"<>Yes")

4
  • Sorry, you are right. I messed up my own calculation. You are right.
    – Mike
    Feb 3, 2022 at 21:13
  • This worked perfectly. Thank you so much!
    – Mike
    Feb 3, 2022 at 21:19
  • Glad to hear this solved your problem. Please take a moment to close this post by marking my answer post as "Best Answer." Thanks.
    – Erik Tyler
    Feb 3, 2022 at 21:38
  • At least I gave you a thumbs up.
    – CodeCamper
    Nov 1, 2022 at 1:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.