+ Reply to Thread
Results 1 to 2 of 2

Using COUNTIF to reference names

  1. #1
    Registered User
    Join Date
    01-18-2005
    Posts
    1

    Using COUNTIF to reference names

    Im trying to create a spreadsheet that helps monitor student participation in my classroom. Id like the spreadsheet to count the instances of a name referenced from another column. This will save me having to tediously enter the names of the students into the column B formula by hand, which is what Ive been doing. In other words, I want to do something like this:

    Column A : contains student names. Bob Smith for example.

    Column B : something like: =COUNTIF(O5:O11,"*(A5)*")
    In other words, it references the name in the first column, and looks in the area O5:O11 (or whatever) to find the instances of the name Bob Smith.

    However, the problem is that it keeps returning a value of 0 for this. It works when you reference a number in column A, but not a set of alphanumeric data. Any ideas how to fix this?
    Last edited by ANDACAR; 01-18-2005 at 12:45 AM.

  2. #2
    Forum Contributor
    Join Date
    09-05-2004
    Location
    Melbourne
    Posts
    193
    This works for me

    =COUNTIF(O5:O12,"*" & A5 & "*")

    Cheers!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1