+ Reply to Thread
Results 1 to 7 of 7

How to count cells from last word in row?

  1. #1
    Registered User
    Join Date
    02-06-2015
    Location
    Croatia
    MS-Off Ver
    MS Office 2013
    Posts
    14

    How to count cells from last word in row?

    Hi everybody, I'm new here and I'm from Croatia.

    I have one question.

    I do some statistics and I have rows like this: (with "" I'll mark blank cell)

    A B C D E F G H I J K L
    1 no x x "" x no x x "" x x x
    2 x x x no x x x x x x x x
    3 x no x x x "" x x x x no ""

    So my question is: What formula is for count, in every row, just cells with "x" but only from last "no" in cell.

    In this case result will be 5 for row 1, 8 for row 2 and 0 for row 3.

    So this formula should automatically find last "no" in row and from that "no" count just "x's".


    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,200

    Re: How to count cells from last word in row?

    Hello Darjan,

    One way:

    =SUMPRODUCT((COLUMN(A1:L1)>MAX((A1:L1="no")*COLUMN(A1:L1)))*(A1:L1="x"))
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: How to count cells from last word in row?

    I went with

    Please Login or Register  to view this content.
    This is an array formula, confirmed with Ctrl+Shift+Enter to exit the cell.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  4. #4
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: How to count cells from last word in row?

    Try:

    Please Login or Register  to view this content.
    My Rules if you want my help:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  5. #5
    Registered User
    Join Date
    02-06-2015
    Location
    Croatia
    MS-Off Ver
    MS Office 2013
    Posts
    14

    Re: How to count cells from last word in row?

    Thank you all for quick replies and for helping me, all formulas works perfect!!

    I'm so happy for I find this forum.

    Therefore you all are so good I have one more question if you could help.

    So I'll take similar example from my first post.
    I need to count maximum just between two "no" in each row.

    I put example in attachment.

    I look forward to your answers.
    Attached Files Attached Files

  6. #6
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: How to count cells from last word in row?

    I could not do that using a formula, but maybe the other guys could.

    I would need to create a user defined function.

    It will take me a few minutes.

    This is your UDF.

    It is in the attached file.

    User =Counter("Your Range") to run it.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 02-06-2015 at 09:25 PM.

  7. #7
    Registered User
    Join Date
    02-06-2015
    Location
    Croatia
    MS-Off Ver
    MS Office 2013
    Posts
    14

    Re: How to count cells from last word in row?

    Thank you for your effort and reply!!

+ 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: 9
    Last Post: 09-30-2014, 09:10 AM
  2. [SOLVED] Count cells within a specific date range that contain a specific word
    By oneillp1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-23-2014, 08:34 AM
  3. Transpose each word in sentence into individual cells/Count the repeat words...???
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-21-2013, 02:38 PM
  4. Replies: 0
    Last Post: 07-28-2013, 10:24 AM
  5. word count within specific cells
    By chuckwag0n in forum Excel General
    Replies: 3
    Last Post: 05-23-2012, 11:09 AM

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