Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Cell with Quotation
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Cell with Quotation
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: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=507704 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Cell with Quotation
=SUM(COUNTIF(A:A,{"*'*","*""*"}))
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "scott" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Cell with Quotation
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Cell with Quotation
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 DataValidation 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Counting values and comparing them to a single cell | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |