View original (French)

Count empty cells in Pivot Table

Solved
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 Contributor 
    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...
    1. Alex
      yes sorry I had a bit of trouble explaining...

      Excel pivot table
    2. Bruce Willix Contributor
      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()).
    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 :)