Good day,

Source statistics:
1. column A contains the names of the characters (the names can be repeated);
2. column B contains the result (win or lose, w and l).

Task: Calculate the number of victories and defeats for a unique hero.

https://docs.google.com/spreadsheets/d/1MS2ca9dEJwcYDo7xPPMdxr3cXTmqJZdusolTAC673YE/edit?usp=sharing

Thank you in advance

    1 answer 1

    Need to use COUNTIFS

    Синтаксис: =countifs(criteria_range1;criteria1;[criteria_range2];[criteria2]...)

    criteria_range1 - range 1, in which the condition 1 is checked
    criteria1 - condition 1
    criteria_range2, 3, ... is a range of 2, 3, etc., in which conditions 2, 3, etc. are checked. respectively
    criteria2, 3, ... - conditions 2, 3

     =COUNTIFS (A:A,F2, B:B,"w") =COUNTIFS (A:A,F2, B:B,"l")