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

  1.
    Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   2 640
     
    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
    1. Alex
       
      yes sorry I had a bit of trouble explaining...

      Excel pivot table
      0
    2. Bruce Willix Posted messages 12376 Registration date   Status Contributor Last intervention   2 640
       
      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
    3. 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