Excel Function SUMIFS is used to get the “total sum” of values for matching criteria across range.
SUMIFS Function is used to get total sum with more than one criteria. It has required arguments i.e. sum_range, criteria_range1, criteria1 and Optional arguments i.e. [criteria_range2, criteria2]… We can place add more than one range to include multiple criteria or conditions.
SUMIFS function is used to get the “total sum” of values for matching criteria across range.
SUMIFS Function has required arguments i.e. sum_range, criteria_range1, criteria1 and Optional arguments i.e. [criteria_range2, criteria2]… We can place add more than one range to include multiple criteria or conditions.
The syntax is as follows:
SUMIF(range, criteria, [sum_range])
sum_range argument is used to give cell range; those are to be added together as per the criteria mentioned below
criteria_range1 argument is used to give the range in which criteria1 needs to find
criteria1 argument is used to give criteria for sum. We can give value (example “A”, >10, 50) or cell reference# (example: E2) in this argument
[criteria_range2] optional argument is used to give the ANOTHER range in which criteria2 needs to find
[criteria2] optional argument is used to give criteria2 for sum. Value or cell reference# can be given.
Kindly note, we can add multiple criteria in the function by separating them with Comma (,)
We will be using SUMIF function as follows:
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us.
Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.
MATCH function performs lookup for a value in a range and returns its position sequence number as output. It has two required and one optional arguments
RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.
Excel Function- WORKDAY.INTL WORKDAY.INTL function is an advanced version of WORKDAY function with additional advantage of “Custom weekend options” For Example, with WORKDAY function weekends are treated as “Saturday and Sundays” however if you need…
INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.