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
I am trying to use
COUNTSIFS with two conditions, but I only end up with an error.
Can anyone help me?