I am trying to count how many times a name appears in a list. Is there a formula?
M myrtlethorn Jul 2, 2008 #1 I am trying to count how many times a name appears in a list. Is there a formula?
S ShaneDevenshire Jul 2, 2008 #2 Hi, use: COUNTIF(List,Name) =COUNTIF(A1:A1000,"Shane") counts the number of times shane appears in the range.
Hi, use: COUNTIF(List,Name) =COUNTIF(A1:A1000,"Shane") counts the number of times shane appears in the range.
R RagDyer Jul 2, 2008 #3 And if Shane Devenshire is in the list, and you want it counted also, try: =COUNTIF(A1:A1000,"Shane*") And for Devenshire, Shane, try: =COUNTIF(A1:A1000,"*Shane") Or =COUNTIF(A1:A1000,"*Shane*")
And if Shane Devenshire is in the list, and you want it counted also, try: =COUNTIF(A1:A1000,"Shane*") And for Devenshire, Shane, try: =COUNTIF(A1:A1000,"*Shane") Or =COUNTIF(A1:A1000,"*Shane*")
