I have a Google Sheet with two columns. One containing a list with order numbers - the order numbers can be listed several times/duplicates. The other column consists of the a free text with the name of one of our delivery partners (fx. UPS or Fedex) - the partner that delivered that specific order.

I want to count the number of unique orders (column A) sent by a specific partner (column B).

I am trying to use COUNTSIFS with two conditions, but I only end up with an error.

Can anyone help me?

enter image description here

  • Welcome. Please share a test sheet with data, expected results and efforts so far. – marikamitsos Jan 9 '20 at 15:12
  • 1
    Solve it. =COUNTA(UNIQUE(QUERY(A2:B; "select A where B='Fedex'"; 0))) – Andreas Jan 10 '20 at 7:50
  • 1
    Great work. Now as per sites guidelines please get some more reputation and write a complete answer instead of just a comment so others can benefit as well. – marikamitsos Jan 10 '20 at 16:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.