Gimmy88
New Member
- Joined
- Dec 19, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi,
I have this matrix:
and I would like to count the number of "1", "2", ecc for each column:
So a kind of countifs where you can set "A" and "1" as parameters.
Any suggestion?
Thanks,
Andrea
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