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

Formula ... Minus Holidays? 1
Changing VBA code to paste values 0
Count IF? 14
Summing non consecutive cells 12
Show last total from 4
Excel Logical Testing 0
Continuing Formula - try 3 1
hlookup in array 2

Top