Forum Discussion
littlebethan
May 23, 2023Copper Contributor
Getting PivotTable to count blank cells
Hi,
I would like to have my PivotTable only count blank cells in a certain column. Is this possible? If so, how?
If it helps, I know the total number of cells, the number of cells with text in so i can figure it out by using a formula but I would much prefer it be in a pivottable so that it can be refreshed easier
Thanks
Bethan
3 Replies
Sort By
Depends on Excel version/platform. Creating PivotTable add data to data model and add the measure
, use it in PivotTable then
- littlebethanCopper Contributor
Thankyou, but im also looking for it to do this per row. So in the below screenshot I want it to show count of blanks in row c rather than count of cells with text
Thanks
So you need number of blanks for Count of Acknowledged instead of count of values for that field, correct? If like
measure will be