Often in Excel 2003, I'm unable to see the result (value) of a formula (ie.
countif, counta). The only way I've found to actually see the result is to
copy the formula and then special paste it as a value. However, I end up
losing the formula when I do that, so I'm not able to get an updated result
without always re-doing the formula.

Does anyone have any advice, or is this just an Excel 2003 glitch??