+ Reply to Thread
Results 1 to 2 of 2

Counting the total number of symbols or characters in multiple rows

  1. #1
    Registered User
    Join Date
    04-08-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    5

    Counting the total number of symbols or characters in multiple rows

    Hi,

    I need help on whether the following counting can be formulate. Couldn't find any clue from existing post similar to the below-mentioned.

    Example I have the following table which I need to set a formula to perform counting of total numbers of "X" and "A":


    Red Blue Orange Yellow White Purple
    Mon X X A X

    Tue X X X A

    Wed X X X A

    Thu X X X A

    Fri X A X X
    ______________________________________________

    Total X 4 2 3 2 3 1
    Total A 0 0 1 1 2 1


    Thanks for your kind assistance. Regards.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Counting the total number of symbols or characters in multiple rows

    I don't think the columns are lining up the way you want them to in your sample.
    However...this formula counts the X's in cells B2:B5
    Please Login or Register  to view this content.

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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