Counting Cell with Quotation

[scott]

In my ss operators enter in numbers to change settings at times the
operatortors forget that all they have to enter is whole numbers and add the
quotation marks. Is there a way to count these quotation marks.
Example--should be 10 they enter 10' or 10"

Thanks Scott

[Dav]

You could try

=SUMPRODUCT(ISTEXT(A1:A100)*1)

Which would count all the non numeric values which is what i guess you want

You could of course use data,validation and set a condition to stop them being entered in the first place, whole number if they are always whole numbers

Regards

Dav

[Bob Phillips]

=SUM(COUNTIF(A:A,{"*'*","*""*"}))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"scott" <[email protected]> wrote in message
news:[email protected]...
> In my ss operators enter in numbers to change settings at times the
> operatortors forget that all they have to enter is whole numbers and add
the
> quotation marks. Is there a way to count these quotation marks.
> Example--should be 10 they enter 10' or 10"
>
> Thanks Scott

[Kevin Vaughn]

Maybe:
=COUNTIF(A1:A11,"10*")+COUNTIF(A1:A11,10)
--
Kevin Vaughn


"scott" wrote:

> In my ss operators enter in numbers to change settings at times the
> operatortors forget that all they have to enter is whole numbers and add the
> quotation marks. Is there a way to count these quotation marks.
> Example--should be 10 they enter 10' or 10"
>
> Thanks Scott

[Ron Coderre]

Instead of trying to account for input errors after entry, why not use Data
Validation to ensure that only valid numbers are entered?

Select the input cells
Data>Validation>
Allow: Whole Number
Data: Between (set the limits)
Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"scott" wrote:

> In my ss operators enter in numbers to change settings at times the
> operatortors forget that all they have to enter is whole numbers and add the
> quotation marks. Is there a way to count these quotation marks.
> Example--should be 10 they enter 10' or 10"
>
> Thanks Scott