Excel Display formula, not result

  • Thread starter Thread starter SPenney
  • Start date Start date
S

SPenney

I'm modifying a formula and rather than the result, Excel is displaying
the formula -- Yes, my equals sign is in place still.

The formula I'm modifying is =SUBTOTAL(9,E2:E45) to
=SUBTOTAL(3,E2:E45)

I'd rather not re'run the subtotal again to get the count I need unless
I can get it on the same line as the sum. When I run them separate, I
am getting two groups when I only want one.

SPenney
 
Your cell may be formatted as Text (which will prevent the parser
from interpreting your leading = sign. If so, reformat as General
and re-edit the formula.
 
Back
Top