Through this simple video i have tried to show you how we can use SUMIFS function to add values based on some conditions. SUMIFS is very useful function to add values. I have tried to make video as simple and short as possible. There is no audio also. Please practice given example and apply the same formula to other files. Only practice will make you good at this.