Counting of Presence of workers in various shifts (i.e. A, B & C) with category

[Akki20]

Base data
Workmen	Presense
Helper	A
Store Keeper	A
Cleaner	B
Helper	C
Helper	B
Helper	Z
Helper	A
Required data is counting of shifts which are A, B and C.
Workmen	Numbers
Helper	4
Store Keeper	1
Cleaner	1

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Weazel]

something like...

Excel 2012

	A	B
1	Workmen	Presense
2	Helper	A
3	Store Keeper	A
4	Cleaner	B
5	Helper	C
6	Helper	B
7	Helper	Z
8	Helper	A
9
10	Workmen	Numbers
11	Helper	4
12	Store Keeper	1
13	Cleaner	1

<tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula B11 =SUM(COUNTIFS($A$1:$A$8,A11,$B$1:$B$8,{"A","B","C"})) <tbody> </tbody>

<tbody>
</tbody>

 

[Akki20]

Thank you very much Mr. Weazel