Log In
Register
Home
How to use COUNTIFS within Pivot Table
Mustapha EL CHAMI
New Member
Members
Forum Posts: 1
Member Since:
October 13, 2022
October 13, 2022
Offline1
October 13, 2022 - 11:41 pm
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.
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members
Trusted Members
Moderators
Power BI
Trusted Members
Moderators
Power BI
Forum Posts: 598
Member Since:
January 31, 2022
January 31, 2022
Offline2
October 15, 2022 - 2:56 pm
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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Saliha Mohamed, David Eva
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Ashley Hughes
Herbie Key
Trevor Pindling
Stevan Kanjo
Erin Sheldon
Nikita Bhatia
Sheilah Taylor
Clare Webber
David Jenssen
Dominic Brosnahan
Forum Stats:
Groups: 3
Forums: 24
Topics: 6526
Posts: 28576
Member Stats:
Guest Posters: 49
Members: 32810
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —