Thread
:
Count if not a number
View Single Post
#
9
Posted to microsoft.public.excel.worksheet.functions
D
external usenet poster
Posts: 121
Count if not a number
I beleive I have found it
=IF(COUNT(K1:K20)=COUNTA(K1:K20)+(COUNTBLANK(K1:K2 0)),"NO","YES")
is there any flaw in this formula, I have tried it with all of the invalid
characters I could thnk of, so far it works
Thanks for all of your help!
"D" wrote:
Still dosent work with the blanks, I tried this formula, but with the same
result.
=IF(COUNT(K1:K20)+(COUNTBLANK(K1:K20))=COUNTA(K1:K 20)+(COUNTBLANK(K1:K20)),"NO","YES")
"Sandy Mann" wrote:
=COUNT(AI7:AT7)+SUM(ISBLANK(AI7:AT7))=COUNTA(AI7:A T7)+SUM(ISBLANK(AI7:AT7))
Agan TRUE or FALSE. If you want something else then use it as the test of
an IF() formula.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"D" wrote in message
...
That is almost what I want, but I need it to treat the blanks the same as
it
treats a space or a coma
"Sandy Mann" wrote:
Does;
=COUNT(AI7:AT7)=COUNTA(AI7:AT7)
which will return TRUE or FALSE doe what you want?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"D" wrote in message
...
I have a range of cells AI7:AT7 and I need a count to see if users made
an
error by entering a blank, a space, a period ect. Where numbers should
have
been enterd. I have tried several count variations and could not come
up
with
any thing.
Reply With Quote
D
View Public Profile
Find all posts by D