Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
21
Views
Topic starter
Hi,
I have 1 column with: 0 - 1 - 2 - 3.
I need to "countif" - I need to count how many 0 and how many 1 ... how many 3 I have in this column - by using Pivot table.
I don't have excel 365 - I have Excel 2019.
Could you support me please.
Posted : 14/10/2022 9:41 am
I suppose you know how to create a Pivot Table. Put the PR field in the Row area and also in the Value area. Then, change the Field setting for the latter to Count rather than Sum. This will count the occurrences of 0, 1, 2, 3 and blanks in the PR column.
Posted : 16/10/2022 12:56 am
