Counting issues...

[Snowmonster]

I have one spreadsheet that counts cells with text in '=COUNT(M88:M92,"*"), but ignores the formulas...
Copied and pasted it to a new spreadsheet, and it doesn't ignore the formulas... can't think to the life of me what I did to getit to do this...

Can anyone help?

Thanks

Snowmonster

[Fotis1991]

Snowmonster. Your request is not so clear. At least for me. Can ypu pls explain a little more or even better to upload a small sample workbook?

[Snowmonster]

Hi...
I have attached the working one 'Sleep Diary', and the not working version 'HrsUpDownTest'...

Sleep Diary M9
HrsUpDownTest O10

Both the same formula, but something is not quite right...

Thanks for replying... hope you can work it out...

Cheers

Snowmonster

[Jonmo1]

There ARE numeric values in O5:O7.
They are 0's, but those are actually numbers.
And you have the option to show zero values UNchecked in the Advanced Options.

[Snowmonster]

Sorted... Thank everyone...

[Jonmo1]

Great, glad to help.