software

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 10quot;

Thanks Scott


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--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=507704=SUM(COUNTIF(A:A,{quot;*'*quot;,quot;*quot;quot;*quot;}))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;scottquot; gt; wrote in message
...
gt; In my ss operators enter in numbers to change settings at times the
gt; operatortors forget that all they have to enter is whole numbers and add
the
gt; quotation marks. Is there a way to count these quotation marks.
gt; Example--should be 10 they enter 10' or 10quot;
gt;
gt; Thanks Scott
Maybe:
=COUNTIF(A1:A11,quot;10*quot;) COUNTIF(A1:A11,10)
--
Kevin Vaughnquot;scottquot; wrote:

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

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
Datagt;Validationgt;
Allow: Whole Number
Data: Between (set the limits)
Click the [OK] button

Does that help?

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

XL2002, WinXP-Proquot;scottquot; wrote:

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