Formula will not work

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
 
M

Mike H

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
 
J

Jim Thomlinson

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

v07 cell shows formula string literal not value returned from formula 1
one cell in my worksheet appears blank, but answr shows in formula 6
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Formula will not calculate 1
Simplifying a formula that prevents negative numbers 3
Excel Excel Formula - IF Function with percentages 1
If cell is blank automatically enter today's date in the same cell 21
Decimal points data not displaying as expected 2

Top