View original (French)

Count empty cells in Pivot Table

Solved
Alex -  
 Alex -
Hello,

I have a column with some empty cells in my database, is it possible to count them? The cell in my pivot table where I would like to see the total number of empty cells (from the database) remains empty (in the value field).

Thank you

1 answer

Answer 1 / 1
Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   2 638
 
I have a column with some empty cells in my database
Yuck, it's not "clean" logically ^^

Question: is it an Excel pivot table or an Access pivot table?

--
Remember remember the fifth of November
Gunpowder, treason and plot.
I see no reason why gunpowder, treason
Should ever be forgot...
0
Alex
 
yes sorry I had a bit of trouble explaining...

Excel pivot table
0
Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   2 638
 
Honestly, the simplest thing is to fill all the empty cells with "(empty)" and then ask the pivot table to display the "Count of {field}"

Alternatively, you can use =COUNTIF(ISBLANK()).
0
Alex
 
It didn't suit me to do it like that; I had set a condition that if there was text in my database cells...

Anyway, I don't think I have much choice; I'm going to do as you said. Thanks anyway :)
0