countif problem

i have employee names in column m2:m16.i am using the countif to count the
number of times an employee shows up in the list.for some strange reason
countif will not work with the name steve!! any suggestions?
thx wynb
--
wynb

Hmmm...

=COUNTIF(M2:M16,"steve")

works for me. Check that there are no leading or trailing spaces.

In article <B624B023-C416-4764-90C5-D2C0A6571B67@microsoft.com>,
WYN <WYN@discussions.microsoft.com> wrote:

> i have employee names in column m2:m16.i am using the countif to count the
> number of times an employee shows up in the list.for some strange reason
> countif will not work with the name steve!! any suggestions?
> thx wynb

Because "steve" in your list and "steve" in your lookup cell or formula is
*not* the same.

Type the name in manually in both places, and you'll see what I mean.

There may be leading or trailing spaces or some other invisible characters
present in one or the other.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"WYN" <WYN@discussions.microsoft.com> wrote in message
news:B624B023-C416-4764-90C5-D2C0A6571B67@microsoft.com...
> i have employee names in column m2:m16.i am using the countif to count the
> number of times an employee shows up in the list.for some strange reason
> countif will not work with the name steve!! any suggestions?
> thx wynb
> --
> wynb

i entered the name manually and it works.thank you. wynb

"Ragdyer" wrote:

> Because "steve" in your list and "steve" in your lookup cell or formula is
> *not* the same.
>
> Type the name in manually in both places, and you'll see what I mean.
>
> There may be leading or trailing spaces or some other invisible characters
> present in one or the other.
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "WYN" <WYN@discussions.microsoft.com> wrote in message
> news:B624B023-C416-4764-90C5-D2C0A6571B67@microsoft.com...
> > i have employee names in column m2:m16.i am using the countif to count the
> > number of times an employee shows up in the list.for some strange reason
> > countif will not work with the name steve!! any suggestions?
> > thx wynb
> > --
> > wynb
>
>

Appreciate the feed-back.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"WYN" <WYN@discussions.microsoft.com> wrote in message
news:C3221DFF-6CF4-4C5A-BEA7-3BB888E4EDE3@microsoft.com...
i entered the name manually and it works.thank you. wynb

"Ragdyer" wrote:

> Because "steve" in your list and "steve" in your lookup cell or formula is
> *not* the same.
>
> Type the name in manually in both places, and you'll see what I mean.
>
> There may be leading or trailing spaces or some other invisible characters
> present in one or the other.
> --
> HTH,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "WYN" <WYN@discussions.microsoft.com> wrote in message
> news:B624B023-C416-4764-90C5-D2C0A6571B67@microsoft.com...
> > i have employee names in column m2:m16.i am using the countif to count
the
> > number of times an employee shows up in the list.for some strange reason
> > countif will not work with the name steve!! any suggestions?
> > thx wynb
> > --
> > wynb
>
>