Formula will not work

  • Thread starter Thread starter WLMPilot
  • Start date Start date
W

WLMPilot

I typed the following formula in and is displays the formula in the cell just
as it was typed in instead of calculating the formula.

=COUNTIF(C8:Q8,"=''")

Those are two single quotes after the equal sign.

What do I need to change or check?

Les
 
most likely

The cell was formatted as text before you typed your formula in
Solution copy the formula reformat as general and paste the formula back

less likely
press Ctrl + `
which is just to the left of the 1 key

Mike
 
The cell is most likely formatted as Text. Change the format to General or a
number style. When that is done you still need to update the cell. Double
click the cell or use 2 on the cell and then exit edit mode.
 

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

copying formulas 3
office 2007 -- formulas 1
Cell shows the last typed text, no matter where it is typed 0
Simplifying a formula that prevents negative numbers 3
Entering a Formula; Remains a Formula Instead of Calculating 1
Countif formula 2
Changing formulas that won't "formulate" 8
formula is not working 2

Back
Top