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: 442
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: Kim Knox, Bhuwan Devkota
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 204
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Bhuwan Devkota
Kathryn Patton
Maria Conatser
Jefferson Granemann
Glen Coulthard
Nikki Fox
Rachele Dickie
Raj Mattoo
Mark Luke
terimeri dooriyan
Forum Stats:
Groups: 3
Forums: 24
Topics: 6221
Posts: 27285
Member Stats:
Guest Posters: 49
Members: 31909
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —