Excel 2013 Tutorial - How to Sum All Values That Meet Two or More Conditions
In this tutorial you will learn :
How to use SUMIFS and SUMPRODUCT functions.
SUMIFS- is a function that can be found to excel 2010 and latest versions, it allows you to use more than one condition.
In the example i will show you , i will use the SUMIFS function to sum all the values of shop 2 from year 2005- 2009.
If You Have An Excel Version Earlier Than 2010 You Can Use The SUMPRODUCT Function Instead Of SUMIFS Function.