Prev: Hlookup with Merged cell as look up value
Next: loan amortization template
From: chadkwelch on 18 Mar 2010 17:25
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
From: T. Valko on 18 Mar 2010 17:40
Try this...

=SUMPRODUCT(--(A1:A10="<0.1"))

--
Biff
Microsoft Excel MVP


"chadkwelch" <chadkwelch(a)discussions.microsoft.com> wrote in message
news:73F17509-1C52-4935-A45D-66DCC63B20C6(a)microsoft.com...
>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


From: Teethless mama on 18 Mar 2010 18:18
=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
From: Ashish Mathur on 20 Mar 2010 23:45
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" <chadkwelch(a)discussions.microsoft.com> wrote in message
news:73F17509-1C52-4935-A45D-66DCC63B20C6(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Hlookup with Merged cell as look up value
Next: loan amortization template