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 excel file and image. Thank you !

This is cross-posted

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"...

www.mrexcel.com

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...

www.vbaexpress.com

Hello friends. Please help ! COUNTIF formula ? [SOLVED]

See cross-post links at bottom of this post. 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...

www.excelforum.com

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"...

chandoo.org

Hello friends. Please help ! COUNTIF formula ?

Hello friends. Please help ! COUNTIF formula ? Excel

www.msofficeforums.com

https://www.excelguru.ca/forums/showthread.php?11543-Hello-friends-Please-help-!-COUNTIF-formula

https://stackoverflow.com/questions/72536529/hello-friends-please-help-countif-formula?noredirect=1#comment128135497_72536529

Hello friends. Please help ! COUNTIF formula ?

Best answer: Hi Realest25, I can't think of (a) function(s) that can do that specific task, so I created one for you. This is the code: Public Function CountVal(mRange As Range, mVal As String) As Integer Dim x As Integer For Each cell In...

ccm.net

 

[pecoflyer]

Do you really expect someone to answer this after bieng posted on so many forums? I won't, that's for sure, I don't have time to loose

 

[vletm]

realest25
You should read this:
A message to forum cross posters

Excelguru Help Site - A message to forum cross posters

post people forums answer issue forum cross time pointed free

www.excelguru.ca

You should reread Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.