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", "D312" 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 bellow url image. Thank you !

ASK — ImgBB


This is cross-posted

Hello friends. Please help ! COUNTIF formula ? | MrExcel Message Board

Hello friends. Please help ! COUNTIF formula ?

Hello friends. Please help ! COUNTIF formula ?

COUNTIF formula ? | Chandoo.org Excel Forums - Become Awesome in Excel

https://www.msofficeforums.com/excel...f-formula.html

Hello friends. Please help ! COUNTIF formula ?

https://stackoverflow.com/questions/...35497_72536529

https://ccm.net/forum/affich-1158037...source=MagNews