|
Excel Articles
Microsoft Excel SumIf Function
The Microsoft Excel SumIf is one of the most used Excel functions, right alongside the Excel Vlookup. Now while the Vlookup is used more than the SumIf, the SumIf is actually more powerful than the Excel Vlookup. Why do I say that, easy, the Vlookup returns a single value, the value of the first match I the list, whereas the Excel SumIf will sum a million or so records, into a single value. The SumIf is kind of like the Excel AutoFilter, where the AutoFilter shows all of the records that match the criteria, the Excel SumIf instead sums those values.
Let’s take an example, suppose you have a worksheet with a data table with records consisting of one million rows in an Excel 2010 workbook, and on a particular worksheet where you want to know the sum of all records that match your criteria. How will you do this? Is the Microsoft Excel SumIf the best function to do so? Let’s think about this. If you want to find the sum of records of for a certain criteria you need to use the SUMIF function in Excel. The function is written as
= SUMIF(range, criteria, [sum_range])
where range = the range of cells which are evaluated to check whether the given condition is satisfied, criteria = that condition which is to be satisfied by the number of cells in the range that is returned by the SUMIF function, sum_range = the range of cells that is to be summed up provided their corresponding cell as defined in the range satisfies the criteria; in case if sum_range is not specified then the range is taken as default sum_range.
That is pretty much it. Yes there are things to watch out for, but basically that is the Microsoft Excel SumIf function.
|
