Forum Discussion

Highpnt1's avatar
Highpnt1
Copper Contributor
Sep 23, 2022

How to display value for blank

I want to count blank value in grand total. How do I display/count it please in the column? 

excel
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Sep 24, 2022

    Highpnt1 

    There is a separate function (COUNTBLANK()) that counts empty cells in a range or array.

    For a whole column you can do this with the following command. Example column A.

    =COUNTBLANK(A:A)

     Is that what you wanted?

    • Highpnt1's avatar
      Highpnt1
      Copper Contributor
      Sep 24, 2022

      dscheikey the COUNTBLANK function did not work for me but thank you. I ended up pulling another field (not needed) down into the values box, along with the actual field I needed the running Grand Total for (blank count to appear/counted as well) renamed that random field I didn't need to Grand Total and the values appeared that I needed. I may not be explaining it correctly or missed a step but thank you🙂

      • dscheikey's avatar
        dscheikey
        Bronze Contributor
        Sep 24, 2022

        Highpnt1 

        I am a little surprised that COUNTBLANK is not working. Does that mean you get an error?

        Which Excel version are you using? COUNTBLANK has been available since Excel version 2007.

         

Resources