asked on
Make pivot table ignore blanks Excel 2010
Can an expert out there tell me how to make my pivot table ignore blanks when counting
So, if I have 200 rows and I want to count how many cells in column named Type Colour contain red, 50 are blank cells 150 contain red so the answer should be 150
Because the pivot includes blanks in the count it returns 200
Thanks
So, if I have 200 rows and I want to count how many cells in column named Type Colour contain red, 50 are blank cells 150 contain red so the answer should be 150
Because the pivot includes blanks in the count it returns 200
Thanks
Microsoft Excel
Last Comment
nutsch
ASKER
sorry for being stupid how do I do that
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Have you removed the explicit value of "(blank)" from the PivotTable filter for the appropriate column?
BFN,
fp.