Count Values on a Matrix

[Gimmy88]

Hi,

I have this matrix:

A	B	C
5	5	6
1	3	5
4	2	6
1	5	6

and I would like to count the number of "1", "2", ecc for each column:

	A	B	C
1	2​	0​	0​
1+2	2​	1​	0​
4	1​	0​	0​
6	0​	0​	3​

So a kind of countifs where you can set "A" and "1" as parameters.

Any suggestion?

Thanks,
Andrea

 

[Gimmy88]

Thank you all!

At the end I found out also this way:

=COUNTIFS(INDEX('Source'!1:1048576,0,MATCH(D14,'Source'!3:3,0)),1)