Forum Discussion
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 i...
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