SUMIFS (with an 'S'!) is an extension of the SUMIF (without an 'S'!) formula and allows is to integrate multiple criteria in the analysis.  For example, we could test an idea such as 'what would returns be if we bet on Man United at home when odds are more than 1.5?'  These formulae can get long, so make sure you are steady and systematic when you put them together.  Take your time and make sure you punch the air when everything works! Oh, and don't forget to validate your calculations as we do in the video.

Topics And Techniques