Help with COUNTIFS and Unique Values formula

[Bergentrude1]

Hi All,

I'm having real trouble trying to run a COUNTIFS formula with multiple criteria and feeding back Unique values to me.

First column "2021 Group NP" - are machines with an output amount. Firstly, I need to count anything here with a 0.

Each machine is assigned to a Group, so in "2021 Group", I need then count Unique values, but only if they did not produce anything as per the previous column.

I've attached a basic view of the sheet here. Can anyone please work their magic and advise?

Many thanks

[Glenn Kennedy]

One way:

=COUNTA(UNIQUE(FILTER(Register[2021 Group],(Register[2021 Groups NP]=0)*(Register[2021 Group]<>0))))

[Bergentrude1]

Fantastic, thank you Glenn, worked perfectly!

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.