|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 18th, 2010, 09:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use CountIf for a literal string
I am trying to count the number of cells in a range that contain the string
0.1. I don't want the number of cells that contain numbers less than 0.1, I want the actual string. Is there an escape character for comparison operators like the tilde for wild cards? Thanks, Chad 
|
|
#2
March 18th, 2010, 09:40 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use CountIf for a literal string
Try this...
=SUMPRODUCT(--(A1:A10="0.1")) -- Biff Microsoft Excel MVP "chadkwelch" wrote in message ... I am trying to count the number of cells in a range that contain the string 0.1. I don't want the number of cells that contain numbers less than 0.1, I want the actual string. Is there an escape character for comparison operators like the tilde for wild cards? Thanks, Chad
|
|
#3
March 18th, 2010, 10:18 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use CountIf for a literal string
=SUMPRODUCT(--(A1:A13="0.1"))
"chadkwelch" wrote: I am trying to count the number of cells in a range that contain the string 0.1. I don't want the number of cells that contain numbers less than 0.1, I want the actual string. Is there an escape character for comparison operators like the tilde for wild cards? Thanks, Chad
|
|
#4
March 21st, 2010, 03:45 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use CountIf for a literal string
Hi,
0.1 is a text string. If this is the only text string in the range, you may use the following formula =COUNTIF(C4:C9,"*") -- Regards, Ashish Mathur Microsoft Excel MVP "chadkwelch" wrote in message ... I am trying to count the number of cells in a range that contain the string 0.1. I don't want the number of cells that contain numbers less than 0.1, I want the actual string. Is there an escape character for comparison operators like the tilde for wild cards? Thanks, Chad
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
