Counting Unfilled Cells in Excel

[Reephdweller]

<p>Each month at work I have do over 120 evaluations on my employees for their phone quality.</p><p>I've created a spreadsheet to enter the score for each evaluation, though I'm curious if there's<br />a formula I can put in that will count each cell that isn't filled in with a grand total so I can tell<br />at a glance how many cells I have left to do. I can probably eyeball it or ballpark it, but just curious<br />if I wanted to know the exact amount.<br /><br />Anyone know the formula I would use to&nbsp;do this?</p>

[cupcakelove]

COUNTBLANK()

[walking joint]

<strong>cupcakelove</strong> wrote:<br />COUNTBLANK() <p>i'll&nbsp;probably never&nbsp;have to use that, but i just tried it and thats pretty cool.&nbsp; </p>

[JPMNICK]

<p>1st posts wins it. </p><p>just put the range in the () and you are done</p><p>&nbsp;</p>

[Reephdweller]

<strong>cupcakelove</strong> wrote:<br />COUNTBLANK() <p>Now that's awesome! Thanks!</p><p>&nbsp;</p>

[sr71blackbird]

Where do you put that formula?<br />

[JPMNICK]

<strong>sr71blackbird</strong> wrote:<br />Where do you put that formula?<br /><p>on the counter next to to the tea bags.</p><p>&nbsp;</p>