Formula will not work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WLMPilot - 13 Mar 2008 21:04 GMT

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

Reply to this Message

Mike H - 13 Mar 2008 21:11 GMT

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

> 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.
[quoted text clipped - 6 lines]
>
> Les

Reply to this Message

Jim Thomlinson - 13 Mar 2008 21:11 GMT

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.

Signature

HTH...

Jim Thomlinson

> 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.
[quoted text clipped - 6 lines]
>
> Les

Reply to this Message