Logic formulas when counting unique clients

I don't have 365 so, using old array formulas:
unique ids across G2:P2

Please Login or Register  to view this content.

Count wash only (G3)

Please Login or Register  to view this content.

Hcut only (G4)

Please Login or Register  to view this content.

both: =G3*G4

Another way.

	F	G	H
3	Wash	7	In G3: =SUM(COUNTIFS($A$2:$A$15,$A$2:$A$15,$C$2:$C$15,$C$2:$C$15,$C$2:$C$15,F3))
4	Haircut	7	In G4: =SUM(COUNTIFS($A$2:$A$15,$A$2:$A$15,$C$2:$C$15,$C$2:$C$15,$C$2:$C$15,F4))
5	Both	4	In G5: =SUM(IF(COUNTIFS($A$2:$A$15,$A$2:$A$15)=2,1))/2

Another option
(with Excel365)

Only Wash

Formula:

Please Login or Register  to view this content.

or with LET function

Formula:

Please Login or Register  to view this content.

Only Haircut

Formula:

Please Login or Register  to view this content.

or with LET function

Formula:

Please Login or Register  to view this content.

Both (Wash and Haircut)

Formula:

Please Login or Register  to view this content.

or with LET function

Formula:

Please Login or Register  to view this content.