Hello friends. Please help ! COUNTIF formula ?

realest25

New member
Joined
Jun 7, 2022
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2019
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
 

AliGW

Administrator
Joined
Nov 8, 2015
Messages
1,786
Reaction score
1
Points
38
Location
Ipswich, Suffolk, England
Excel Version(s)
MS 365 (Beta Insider Channel)
Why on Earth would you cluster bomb the Internet in this way? For information, these links need to be shared on each of the forums where you have posted the same quesry. Please note, though, that using this approach is likely to lead to no help being offered anywhere - nobody is going to have time to check so many different places to see if your question has already been answered.

I would strongly advise against using this MO in future.
 
Top