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?
Excel for Mac 2011
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?
Excel for Mac 2011
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.