+ Reply to Thread
Results 1 to 3 of 3

Count the number of cells

  1. 03-14-2009, 05:35 AM #1
    Dyzone
    Dyzone is offline
    Registered User
    Join Date
    03-10-2009
    Location
    AC
    MS-Off Ver
    Excel 2003, 2007
    Posts
    16

    Count the number of cells

    Hi great people of this Forum!

    Could you please help with this problem:

    I need to count the number of cells that has a certain criteria. Let’s say how many A or B’s etc.….. has values? It should not count the blank cells.

    ------ ------
    Letters Value(s)
    A 12
    B 1
    B 2
    C 3
    C 4
    A 23
    A
    A 1
    B 4
    C
    D 1
    A 45
    A 3

    I have attached a sample sheet.

    Thanks a lot guys.
    Attached Files Attached Files
    Last edited by Dyzone; 03-17-2009 at 09:26 AM.
    Reply With QuoteRegister To Reply
  2. 03-14-2009, 09:59 AM #2
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Count the number of cells

    Hi and welcome to the board
    Does the attached file help?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 03-14-2009, 10:29 AM #3
    Dyzone
    Dyzone is offline
    Registered User
    Join Date
    03-10-2009
    Location
    AC
    MS-Off Ver
    Excel 2003, 2007
    Posts
    16

    Re: Count the number of cells

    I checked the attached and Yes!!, Big Help Arthurbr, Thanks! Keep up the good work!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1