Spreadsheet: 115114d1310735344-vlookup-and-sumifs-example
Sheet: Games per Team

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Month
Country | Equipo | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00
Argentina | AC Milan | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 3
Argentina | Internazionale | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1
Argentina | Napoli | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 1
Argentina | Udinese | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 3 | 4 | 5 | 2 | 4 | 5 | 1 | 3 | 6 | 7 | 7 | 2 | 2
Argentina | [NAME] | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 4 | 5 | 6 | 3 | 5 | 6 | 2 | 4 | 7 | 8 | 8 | 3 | 3
Argentina | AS Roma | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1
Argentina | Juventus | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 2 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 3 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 6 | 6 | 1 | 1 | 1