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 i...
excel
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