+ Reply to Thread
Results 1 to 5 of 5

Need some help with counting words

  1. #1
    Registered User
    Join Date
    06-23-2021
    Location
    Prince Edward Island, Canada
    MS-Off Ver
    Office 365
    Posts
    13

    Need some help with counting words

    I am working on membership analysis. The board wants to know what the male/female ratio is.

    I have pulled a report from our membership management system. There is no direct info in wether the member is male/female other than their Honorific (Mr., Ms., Mrs., Miss, Monsieur, Mme etc.).
    I kind of want to use the COUNTIF formula (or if there is a better one, please let me know), but instead of using one term (such as Mr.), I want to count the cells that contain the words Mr., Monsieur etc.
    Obviously I would like to do the same for the female variant. However I noticed they use many different kind of terms. So, I could also count the total members and subtract the males to get the total female.

    Any ideas of how to tackle this?

    Thanks!
    Attached Files Attached Files
    Last edited by Platje; 06-23-2021 at 11:34 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,318

    Re: Need some help with counting words

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.

    Your version of Office is 365 (days in a year), not 360 (degrees in a circle). You may wish to update your profile.
    Last edited by AliGW; 06-23-2021 at 11:22 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,889

    Re: Need some help with counting words

    One way:

    =SUMPRODUCT(--ISNUMBER(SEARCH({"Mr ","Monsieur "},$A$1:$A$10)))

    NB... space after Mr etc, is intentional.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Registered User
    Join Date
    06-23-2021
    Location
    Prince Edward Island, Canada
    MS-Off Ver
    Office 365
    Posts
    13

    Re: Need some help with counting words

    Thanks for all the help! My apologies for the late response, I don't know what I was thinking!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,318

    Re: Need some help with counting words

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. [SOLVED] counting occurrence of specific words in another group of words
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2021, 07:33 PM
  2. [SOLVED] Counting Words?
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-28-2018, 02:48 PM
  3. Counting words in RED
    By Venkat_Discover in forum Excel General
    Replies: 2
    Last Post: 08-11-2017, 09:54 PM
  4. Counting occurrences not values.. Counting blocks of words in columns
    By Flydd in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-01-2016, 06:42 PM
  5. [SOLVED] Counting Words
    By corn1991 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-18-2015, 09:09 AM
  6. counting words
    By Duckie in forum Excel General
    Replies: 2
    Last Post: 01-18-2010, 07:28 PM
  7. Counting words............
    By Smokey_Vol in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-21-2005, 11:35 AM

Tags for this Thread

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