Hello friends. Please help ! COUNTIF formula ?

[realest25]

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

[snb]

Please post an Excel file; the picture is too small.

[Aflatoon]

FYI, cross-posted:
https://www.excelguru.ca/forums/show...OUNTIF-formula
https://www.mrexcel.com/board/thread...rmula.1207187/
https://www.excelforum.com/excel-for...f-formula.html
https://chandoo.org/forum/threads/co...formula.48174/
https://www.msofficeforums.com/excel...f-formula.html
https://stackoverflow.com/questions/...ountif-formula
https://ccm.net/forum/affich-1158037...ountif-formula

[Aussiebear]

@realest25. Please follow this link to understand why multicasting is frowned upon in almost all forums. https://www.excelguru.ca/content.php?184