0
I basically have the following list:
How can I count the amount of times John won?
I have tried using both countif and countifs but have find no positive result. I either get "#VALUE!" or a simple "0"
I'm still new to this but I couldn't find an answer online.
Lorenzo Jung
Posted 2016-05-14T23:19:42.223
Reputation: 3
0
Use this formula to count how many times John has won:
=COUNTIFS(A:A,"John",C:C,"Won")
Or use this dynamic formula in D2 and apply to all rows (you will have their winning count repeat next to any occurrence of their name):
=COUNTIFS(A:A,A2,C:C,"Won")
Adding the D column to your example, it would look like this:
Atzmon
Posted 2016-05-14T23:19:42.223
Reputation: 2 639
I tried using both the formulas you told me but I receive an ERROR:508 – Lorenzo Jung – 2016-05-14T23:34:05.447
I've tested this in Excel. Are you using Excel or opening an Excel file in another application? – Atzmon – 2016-05-14T23:36:17.493
Oh I'm using openoffice calc. I thought they both had the same basic formulas – Lorenzo Jung – 2016-05-14T23:37:28.023
I suppose the equivalent function would be
=COUNTIFS(A:A;"John";C:C;"Won")but I cannot test it at the moment. – Atzmon – 2016-05-14T23:42:35.697Thanks for your help I used =CONT.SES(A1:A6;"John";C1:C6;"Won") which is basically =COUNTIFS(A1:A6;"John";C1:C6;"Won") but in portuguese. Do I need to do something to mark this question as "ANSWERED"? – Lorenzo Jung – 2016-05-14T23:46:23.700
If my answer helped than please mark it as answered. You should at least tag this question with
libreoffice-calcto clarify it refers to LibreOffice Calc and not Microsoft Excel as I mistakenly assumed. – Atzmon – 2016-05-14T23:49:48.327