Formula Problems

A

Ayo

I have never had this problem before. In fact the is the first time I am
seeing this. I enter a formula "=sum(F13:F14)" in a cell and it doesn't
evaluate. It just shows the formula.
 
O

OssieMac

I am assuming that the double quotes are only for this post and that you have
not included them in the formula. If so, then remove them.

Otherwise my guess is that the cell is formatted as Text. Re-format the cell
to general (or other number format)
 
O

OssieMac

After re-formatting you will probably have to edit the cell to get the
formula to work. Just select the cell, press F2 then Enter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 365 Signatures 0
Copy addition formula of non-consecutive horizontal cells 2
Formula ... Minus Holidays? 1
Using SUM(INDIRECT()) 2
Amending meeting cancels all future meetings 0
Automatic Emails sent to my Contact Groups by Microsoft 1
Cumulative formula for word table 0
Count IF? 7

Top