fuction which counts not empty cells in a column and shows how many of it a given text

[precike123]

Hi Guys!

I am looking for a function which counts how many not empty cells in a column and than it shows that how many are a text string like "Win" So actually I have a column with texts: Win or Lose and I want to count how many of these cells are "Win" out of all win and lose.

Thank you all the help,

Martin

[Limor_OP]

Maybe:
=COUNTIF(A:A,"WIN")

[precike123]

It is not working for me. And I think it should be 2 function or 2 in 1 because it has to count how many cells are not empty in a column and how many are "Win".

[AliGW]

You said in the workbook that you wanted this:

=COUNTIF(A:A;"<>")

and this:

=COUNTIF(A:A;"WIN")

; for a European locale

but you did NOT tell us the values that you were expecting. You still haven't told us this, so the ball is in your court.

[precike123]

I am sorry I am a beginner, but what do you mean by value? These functions you wrote are not working for me, maybe because I want to count texts and not numbers? So If I rewrite the "Win" to "1" and "Lose" to "2" it will work maybe.

[precike123]

I tried it with numbers instead of text and still says: #NAME?

[AliGW]

You do not say in what way you think they don't work. COUNTIF is designed to count text or numbers AND it works for me on your data:

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F
1	Win		14	=COUNTIF(A:A,"<>")
2	Win		10	=COUNTIF(A:A,"WIN")
3	Win
4	Lose
5	Win
6	Win
7	Win
8	Win
9	Lose
10	Lose
11	Win
12	Lose
13	Win
14	Win

Sheet: Munka1

So more details, please. Maybe your sample data is too different to your real data.

[precike123]

I am triing in on the sample sheet exactly like your example with ; instead of , and still says: #NAME?

[AliGW]

You need to use the Hungarian version of the function!!!

=DARABTELI(A:A;"<>")

=DARABTELI(A:A;"WIN")

https://en.excel-translator.de/translator/

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

[precike123]

Works with the Hungarian function, thank you very much for your help and patient. Have a nice day.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.