Sep 23 2022 05:49 AM
I want to count blank value in grand total. How do I display/count it please in the column?
Sep 24 2022 04:05 AM
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?
Sep 24 2022 05:01 AM
@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:)
Sep 24 2022 05:58 AM
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.