Pivot Table counts an empty cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am counting inventory in a pivot table. I want the item to show in the
Column, but I do not want an empty cell to show in the counts, which it does
now.

How do I prevent empty cells from counting, but show the item itself?

Thanks

Dave
 
If you're using Count as the function, then empty cells won't increase that
number.

But if you have a formula in that field that evaluates to "", then the cell
isn't empty and will be included in that count.

In fact, if you had a formula that evaluated to "" and then converted to values,
the cell is still not empty and that cell will increase the count.

I like to add another field and use a formula like:

=if(a2="",0,1)
and then sum (not count) that field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table 1
Pivot Tables - Count Numbers vs. Count 1
Data Lookup Question 1
Count outside of pivot table 2
Pivot Table 1
Pivot table filter list - listing irrelevant subcategorys 1
How to count the number of cells not empty? 9
In a pivot table, can the avg of a column include rows w/o data? 2

Back
Top