COUNTIF's calculating sum of unique values meeting one bit of criteria, no duplicates

[Stellar114]

I'm trying to find a formula that will calculate a total of orders effected based off of whether another column is yes, or no, exclude duplicate values of sales orders, and exclude blanks.

Based on the data below, i'm looking to sum the total number of sales orders (column "A") IF column B = YES, but exclude duplicate sales orders, and ignore blank cells.

I've tried manipulating a COUNTIFS formula, but no luck. Any help would be appreciated!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=ROWS(UNIQUE(FILTER(A2:A1000,I2:I1000="yes")))

 

[Stellar114]

Hi & welcome to MrExcel.
How about

=ROWS(UNIQUE(FILTER(A2:A1000,I2:I1000="yes")))

Awesome! Thank you so much for this. This formula works perfectly! You're a life saver.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Stellar114]

Hi,

Can this formula be applied with another bit of criteria? Say i wanted to calculate How many times each unique value in column A occurs if "I" is yes, and "J" is "move"? If not, what would be the proper formula for that?

 

[Fluff]

You can add further criteria like

=ROWS(UNIQUE(FILTER(A2:A1000,(I2:I1000="yes")*(J2J1000="move"))))