Forum

Notifications
Clear all

How to use COUNTIFS within Pivot Table

2 Posts
2 Users
0 Reactions
186 Views
(@mustapha-el-chami)
Posts: 1
New Member
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
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

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
Share: