Forum Discussion

littlebethan's avatar
littlebethan
Copper Contributor
May 23, 2023

Getting PivotTable to count blank cells

Hi,

 

I would like to have my PivotTable only count blank cells in a certain column. Is this possible? If so, how?

 

If it helps, I know the total number of cells, the number of cells with text in so i can figure it out by using a formula but I would much prefer it be in a pivottable so that it can be refreshed easier

 

Thanks

Bethan

excel

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 23, 2023

    littlebethan 

    Depends on Excel version/platform. Creating PivotTable add data to data model and add the measure

    , use it in PivotTable then

    • littlebethan's avatar
      littlebethan
      Copper Contributor
      May 23, 2023

      SergeiBaklan 

       

      Thankyou, but im also looking for it to do this per row. So in the below screenshot I want it to show count of blanks in row c rather than count of cells with text

       

       

      Thanks

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 23, 2023

        littlebethan 

        So you need number of blanks for Count of Acknowledged instead of count of values for that field, correct? If like

        measure will be

Resources