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 !

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: COUNTIF formula ?
also Hello friends. Please help ! COUNTIF formula ?
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[alansidman]

and here also: Excelguru.ca

 

[realest25]

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 ?

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

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

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

Hello friends. Please help ! COUNTIF formula?

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

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

ccm.net