+ Reply to Thread
Results 1 to 5 of 5

Counting Symbol Checkmarks

  1. #1
    Forum Contributor
    Join Date
    03-30-2008
    Posts
    121

    Counting Symbol Checkmarks

    I would like to count all fields which contain the
    symbol checkmark.

    In another instance I am using the formula
    =COUNTIF(B124:B137,"X") to count all fields
    which contain an X.

    However I don't know the reference for the
    symbol checkmark.

    Thanks.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669
    What font are you using for the checkmark?

    If Wingdings, =COUNTIF(rng, CHAR(252))
    Last edited by shg; 10-19-2008 at 01:15 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    03-30-2008
    Posts
    121

    Wingdings Bold

    I am using Windings Bold....is that
    a different reference for bold because
    the formula you provided gives me a
    #NAME? error.

    Thanks.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669
    Replace rng with your actual range: =COUNTIF(B124:B137, CHAR(252))

  5. #5
    Forum Contributor
    Join Date
    03-30-2008
    Posts
    121

    Thanks.

    Thanks for your help.

    It works like a charm.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. stock symbol list
    By dismal in forum Excel General
    Replies: 2
    Last Post: 09-11-2008, 11:48 AM
  2. sigma (symbol)
    By arora in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2008, 05:33 AM
  3. Counting cells with formulas
    By baz0912 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-21-2008, 09:31 AM
  4. How to start counting the hours in a month
    By kdraper in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2007, 06:25 PM
  5. grab all info right of @ symbol
    By DKY in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2007, 02:31 PM

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