Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
#3
|
|||
|
|||
Hmmm...
=COUNTIF(M2:M16,"steve") works for me. Check that there are no leading or trailing spaces. In article , WYN 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 |
#4
|
|||
|
|||
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" wrote in message ... 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 |
#5
|
|||
|
|||
Appreciate the feed-back.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "WYN" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF or SUMIF Problem | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
problem with countif | Excel Worksheet Functions | |||
Countif Problem | Excel Worksheet Functions |