View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Formula will not work

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

"WLMPilot" wrote:

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