Consulting

Results 1 to 4 of 4

Thread: Hello friends. Please help ! COUNTIF formula ?

  1. #1

    Hello friends. Please help ! COUNTIF formula ?

    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.jpg
    Last edited by SamT; 06-07-2022 at 05:40 PM.

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,577
    Please post an Excel file; the picture is too small.

  3. #3

  4. #4
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,178
    Location
    @realest25. Please follow this link to understand why multicasting is frowned upon in almost all forums. https://www.excelguru.ca/content.php?184
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •