+ Reply to Thread
Results 1 to 6 of 6

Hello friends. Please help ! COUNTIF formula ?

  1. #1
    Registered User
    Join Date
    12-05-2021
    Location
    Bucharest, Romania
    MS-Off Ver
    2019
    Posts
    2

    Hello friends. Please help ! COUNTIF formula ?

    See cross-post links at bottom of this post.

    Hello friends. Please help !

    I want a formula ( maybe COUNTIF? ) to count how many "W" and "D" and "L" are found per each range: "B3:B12", "D3:D12" and "F3:F12".

    But to count only in the first 5 cells with value (that are NOT empty blank cells).

    I don't want to count all "W" and "D" and "L" found in the entire range.

    I want to count "W" and "D" and "L" on the first 5 filled cells, skiping the blank cells.

    The formulas must be separate, meaning a formula to count just the value "W", another formula to count just the value "D", another formula to count just the value "L".

    In short, to count in the first 5 cells that are not blank:
    - how many "W"
    - how many "D"
    - how many "L"

    I want to obtain the count from the green examples.

    I DO NOT want to obtain the count from the red examples.

    Please see attached image. Thank you !

    ASK.PNG

    Cross-posted:
    https://www.mrexcel.com/board/thread...rmula.1207187/
    http://www.vbaexpress.com/forum/show...OUNTIF-formula
    https://chandoo.org/forum/threads/co...formula.48174/
    https://www.msofficeforums.com/excel...f-formula.html
    https://www.excelguru.ca/forums/show...OUNTIF-formula
    https://stackoverflow.com/questions/...35497_72536529
    https://ccm.net/forum/affich-1158037...source=MagNews
    Last edited by 6StringJazzer; 06-08-2022 at 10:33 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Hello friends. Please help ! COUNTIF formula ?

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on many other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Hello friends. Please help ! COUNTIF formula ?

    Because it's the member's first post, they are not allowed to post links. To ease this process I have taken the liberty of copying the links from his post in another forum and editing the OP.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    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,893

    Re: Hello friends. Please help ! COUNTIF formula ?

    The reason we ask you to provide information about crossposts is that none of us wants to waste our time developing a solution when you already have one.

    You have splattered this Q all over the internet. It would take longer to check them all than it did to produce this:

    =COUNTIF(A$2:INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$20)/($A$2:$A$20<>""),5)),C2)

    copied down.
    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

  5. #5
    Registered User
    Join Date
    12-05-2021
    Location
    Bucharest, Romania
    MS-Off Ver
    2019
    Posts
    2

    Re: Hello friends. Please help ! COUNTIF formula ?

    Thank you very much for your reply Mr Glenn Kennedy. God Bless You !

  6. #6
    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,893

    Re: Hello friends. Please help ! COUNTIF formula ?

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) 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] Help with countif formula for calendar (countif any date in table present)
    By KMJ256388 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-25-2021, 12:11 PM
  2. Faster if/countif formula for flagging uniques - countif too slow
    By Speshul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2015, 01:44 PM
  3. excel formula and VBA not friends
    By marshall_massive in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2013, 09:11 AM
  4. Hi friends..
    By kobra058 in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 02-06-2013, 01:46 AM
  5. Hello Friends :)
    By mandeeps207 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-02-2013, 01:53 AM
  6. What are Friends for ?
    By Pete_UK in forum The Water Cooler
    Replies: 5
    Last Post: 11-01-2012, 11:33 PM
  7. hi friends
    By bujji1305 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-11-2012, 07:58 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