Count for multiple categories

[anneb_87]

Hi Experts!

I need to fill in the count of the following clients:
Category ClientA ClientB ClientC
Medical
Dental
Vision


Here is the source data:
Client Category
ClientA Medical
ClientA Dental
ClientB Vision
ClientC Dental


What should I do?

 

[Toadstool]

	A	B	C	D	E	F	G	H
1	Client	Category			Category	ClientA	ClientB	ClientC
2	ClientA	Medical			Medical	1	0	0
3	ClientA	Dental			Dental	1	0	1
4	ClientB	Vision			Vision	0	1	0
5	ClientC	Dental

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula F2 Copy & Paste to H4 =COUNTIFS($A:$A,F$1,$B:$B,$E2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>