Amend formula to count unique text in a range

[Nick70]

Hi,

I have a formula to count unique text in a range based on certain conditions (see below):

=ROWS(UNIQUE(FILTER(C4:C17,(B4:B17="client a")*(D4:D17="February")*(E4:E17=2021))))

Is it possible to add 1 more condition for range (B4:B17) on top of (B4:B17="client a")?

The new condition would be (B4:B17="client b") so the conditions we now have to take into account are:

(B4:B17="client a")*(B4:B17="client b")*(D4:D17="February")*(E4:E17=2021)

Is this something possible?
How would formula look?
Otherwise is there another way (even using VBA) to calculate unique text based on conditions below?
(B4:B17="client a")*(B4:B17="client b")*(D4:D17="February")*(E4:E17=2021)

Thanks,
Nic

 

[Fluff]

How about

=ROWS(UNIQUE(FILTER(C4:C17,((B4:B17="client a")+(B4:B17="client b"))*(D4:D17="February")*(E4:E17=2021))))

 

[Nick70]

Perfect!!!
That works really well.

Thanks,
Nic

 

[Fluff]

You're welcome & thanks for the feedback.