You're close. CountIf() is going to give you trouble. Use CountA() instead, as in:

=COUNTA(C:C)-1

The "minus 1" is to account for your Comment column heading.

I never thought that I'd see an Excel question here! smile

What's next, Monarch questions? wink