Counting blank cell

[littlefoot]

Hello,

I know I could hide the column, but how do I stop the Pivot Table counting my blank cells?

I have a formula in cells C2:E2, Even when I copy and paste C2:E2 as values the Pivot Table still seems to count the blank cells. What am i doing wrong? Is my formula incorrect?

Example attached.

Thanks in advance for any help

[Glenn Kennedy]

Go into row labels and column labels int he Pivot Table and deselect the blanks...

[Richard Buttrey]

Hi,

You could use the Filter drop down and untick the 'blanks'

[littlefoot]

Thanks. Played further with pivot table and managed to get results I need.
Thank again for help.

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.