Excel Tricks with Tejraj

In this blog post we will learn to about SUMIFS function in excel. In our previous blog post we learned about SUMIF function in which we learned to calculate the SUM based on certain criteria or condition. In this blog post we will learn to calculate the sum based on set of criteria’s or conditions, with the help of SUMIFS function. Where to find SUMIFS function on Excel Screen: SUMIFS function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. SUMIFS function is highlighted in blue in below image. Once we click on SUMIFS option as highlighted above, we will get the function argument dialog box as shown in below image. Syntax of SUMIFS Function: The Syntax of SUMIFS function is as below: =SUMIFS(sum_range, cirteria_range1, cirteria1, …) Arguments of SUMIFS Function: SUMIFS fun...

In this blog post we will learn to about SUMIF function in excel. Whenever we want to calculate the SUM based on certain criteria or condition, we can use the SUMIF function. Where to find SUMIF function on Excel Screen: SUMIF function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. SUMIF function is highlighted with blue color in below image. Once we click on SUMIF option as highlighted above, we will get the function argument dialog box as shown in below image. Syntax of SUMIF Function: The Syntax of SUMIF function is as below: =SUMIF(range, criteria, [sum_range]) Arguments of SUMIF Function: SUMIF function takes three arguments as listed below: range : It is cell range which you want to evaluate or in other words, it is cell range from which we want to apply condition or ...