Consulting

Results 1 to 4 of 4

Thread: Hello friends. Please help ! COUNTIF formula ?

Threaded View

Previous Post Previous Post   Next Post Next Post
  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.

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
  •