Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 911
  • Last Modified:

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
0
Jagwarman
Asked:
Jagwarman
1 Solution
 
[ fanpages ]IT Services ConsultantCommented:
Hi,

Have you removed the explicit value of "(blank)" from the PivotTable filter for the appropriate column?

BFN,

fp.
0
 
JagwarmanAuthor Commented:
sorry for being stupid how do I do that
0
 
nutschCommented:
Actually, if you include the type column as a row or column field in your pivot, in addition to as data field, you should only get 150 for red.

Thomas
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now