How to display value for blank

Copper Contributor

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

3 Replies

@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?

@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:)

@Highpnt1 

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

dscheikey_0-1664023880392.png

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