New to formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-3088121%22%20slang%3D%22en-US%22%3ENew%20to%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3088121%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EIm%20try%20to%20find%20out%20the%20number%20of%20wins%20%26amp%3B%20losses%20played%20by%20a%20group%20of%20people.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20formula%20do%20I%20use%20to%20%26amp%3B%20how%20do%20I%20set%20it%20up%20to%20get%20each%20player%20the%20total%20number%20of%20wins%20%26amp%3B%20losses%20they%20have%20had%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3088121%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3088147%22%20slang%3D%22en-US%22%3ERe%3A%20New%20to%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3088147%22%20slang%3D%22en-US%22%3EHello%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20would%20use%20sumifs%20formula%2C%20so%20you%20can%20get%20to%20total%20of%20each%20group%20wins%20and%20losses.%3CBR%20%2F%3Eif%20you%20need%20more%20help%20send%20your%20excel%20sheet%20so%20we%20can%20work%20on%20it.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi 

Im try to find out the number of wins & losses played by a group of people.

 

What formula do I use to & how do I set it up to get each player the total number of wins & losses they have had

 

Thanks

1 Reply
Hello

You would use sumifs formula, so you can get to total of each group wins and losses.
if you need more help send your excel sheet so we can work on it.