counting

[Spikenaylor]

my table is like below

I need to count how many r there are for all process only for Quality (5)
I need to count how many r there are for all process only for SHE (2)

etc

Many thanks for any help

Process	Day	01	02	03	04	05	06	07	08	09
Process 1	Quality	n	r	g	a	r	g	g	a	g
Process 1	SHE	n	r	g	g	a	g	g	a	g
Process 2	Quality	n	g	g	g	r	r	g	r	g
Process 2	SHE	n	g	g	g	g	a	g	r	g

<tbody>
</tbody>

 

[Weazel]

something like...

Unknown

	A	B	C	D	E	F	G	H	I	J	K
1	Process	Day	1	2	3	4	5	6	7	8	9
2	Process 1	Quality	n	r	g	a	r	g	g	a	g
3	Process 1	SHE	n	r	g	g	a	g	g	a	g
4	Process 2	Quality	n	g	g	g	r	r	g	r	g
5	Process 2	SHE	n	g	g	g	g	a	g	r	g
6
7		5
8		2

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B7 =SUMPRODUCT((B2:B5="Quality")*(C2:K5="r")) B8 =SUMPRODUCT((B2:B5="SHE")*(C2:K5="r")) <tbody> </tbody>

<tbody>
</tbody>

 

[Spikenaylor]

I am getting old. I have used this before and forgotten.
Many thanks