+ Reply to Thread
Results 1 to 6 of 6

Count X with the specified starting date

  1. #1
    Registered User
    Join Date
    05-18-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2010
    Posts
    26

    Count X with the specified starting date

    i need the count of 'X' in each row based on the specified date (column A) as starting point.
    Attached Images Attached Images

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Count X with the specified starting date

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    05-18-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2010
    Posts
    26

    Re: Count X with the specified starting date

    here's the sample data, the output should be in total column.
    Attached Files Attached Files

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Count X with the specified starting date

    Put this formula in W4:

    =COUNTIFS($B$3:$V$3,">="&$A4,B4:V4,"x")

    then copy down.

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    05-18-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2010
    Posts
    26

    Re: Count X with the specified starting date

    Quote Originally Posted by Pete_UK View Post
    Put this formula in W4:

    =COUNTIFS($B$3:$V$3,">="&$A4,B4:V4,"x")

    then copy down.

    Hope this helps.

    Pete
    thanks Pete,

    this helps a lot.

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Count X with the specified starting date

    Glad to hear it, and thanks for the rep.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

    Pete

+ 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. How to indicate 'starting' value for LastRow = (...)Rows.Count,1) (...)
    By Marcych in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2018, 07:19 PM
  2. Replies: 2
    Last Post: 10-23-2014, 09:57 AM
  3. [SOLVED] Show the week nukmber of todays date from a starting date
    By john dalton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2014, 05:27 AM
  4. Replies: 4
    Last Post: 02-06-2014, 04:24 PM
  5. Replies: 4
    Last Post: 01-18-2013, 05:10 AM
  6. Count rows starting in particular row
    By bosco2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-27-2011, 02:20 PM
  7. Replies: 2
    Last Post: 09-13-2010, 12:46 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