+ Reply to Thread
Results 1 to 5 of 5

Count the number of times a letter appears next to a word.

  1. #1
    Registered User
    Join Date
    09-29-2020
    Location
    Australia
    MS-Off Ver
    MS 16
    Posts
    2

    Count the number of times a letter appears next to a word.

    Hello all,

    I am having trouble finding the right formula to count the number of 'W's in Column Q that are against the the word in Column D. This would total the number of W's in Cell C24 and C25 and so on. I tried this one (and many others) =SUM(IFERROR(IF(SEARCH(A25,$D$2:$D$6)>W,$Q$2:$Q$6,0),0)). I think Im on the right track (Um maybe not either)
    For example see attached spread sheet.

    Any help would be appreciated.
    Thanks Geoff
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-15-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    75

    Re: Count the number of times a letter appears next to a word.

    Hi,

    Try this in C25, then modify as required.

    =COUNTIFS(D4:D7,A25,Q4:Q7,"W")

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Count the number of times a letter appears next to a word.

    Try Countifs:

    =COUNTIFS($D$4:$D$9,A25,$Q$4:$Q$9,"W")
    Quang PT

  4. #4
    Registered User
    Join Date
    09-29-2020
    Location
    Australia
    MS-Off Ver
    MS 16
    Posts
    2

    Re: Count the number of times a letter appears next to a word.

    Awesome works perfectly!! Damn easy formula too!!!

  5. #5
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Count the number of times a letter appears next to a word.

    C25 cell formula
    HTML Code: 

+ 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. Replies: 4
    Last Post: 07-05-2017, 06:32 AM
  2. Count number of times a specific word appears
    By csepesy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2017, 09:48 PM
  3. count number of times the letter "a" appears in a cell
    By mohammadkhajoo in forum Excel General
    Replies: 8
    Last Post: 05-31-2014, 07:48 PM
  4. [SOLVED] count number of times a word appears
    By m_789 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-19-2013, 10:16 AM
  5. [SOLVED] Want to count the number of times a particular letter appears within a range
    By dwhite30518 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-11-2013, 01:24 PM
  6. Replies: 8
    Last Post: 07-05-2012, 03:07 PM
  7. count the number of times a specific word appears in a column
    By BAR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2006, 12:10 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