3

My Pivot Table totals the occurance of various strings in my column. Some of the cells are blank. I want the "blank" category to display a total count. How is this done?

Similar unanswered question

Excel for Mac 2011

1

1 Answer 1

2

You can't count blank cells in an Excel Pivot table. There are workarounds to this. I have used conditional formatting in my table and counted the numbers. See this article to see other workarounds.

Count Blank Cells Workaround

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .