Using Countifs to ONLY COUNT numbers NOT FORMULAS

Try this:

=COUNTIFS(A:A,"< >Total*",C:C,">0")

I assume from your screen shots that you are NOT using XL2003 - please update your profile.

Hope this helps.

Pete