Count by character across vertical and horizontal criteria

[captainyemen]

Hi guys,

I'm trying to do an assessment of products (components) across markets (cz,de as examples per picture), but am finding it difficult to put a simple summary table just to tally up the totals based on characters.

Is there a way of me doing 2 counts without a pivot-table (as I can't get it to group right). I was trying to get a sum product to work but am failing miserably

Thank you,
CY

 

[Trevor G]

What about this

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Market	Comp 1	Comp 2	Comp 3	Comp 4	Comp 5	Comp 6	Comp 7	Comp 8	Comp 9	Comp 10	Comp 11	Comp 12	Comp 13	Comp 14
2	CZ				P
3	CZ										M
4	CZ														H
5	CZ						H
6	CZ									R
7	CZ			N
8	DE				P
9	DE										P
10	DE														H
11	DE						H
12	DE									R
13	DE			N
Sheet4

Formula used

Excel Workbook
	T	U	V
1	Market	Character	Count
2	CZ	P	1
3	CZ	M	1
4	CZ	H	2
5	CZ	R	1
6	CZ	N	1
7	DE	P	2
8	DE	M	0
9	DE	H	2
10	DE	R	1
11	DE	N	1
Sheet4