30Sep2014

SUMIF and SUMIFS

SUMIF: SUMIF function in Microsoft Excel, adds the cells specified by a criteria. Syntax for this excel function =Sumif(range, criteria, sum range) Sumif formula can be used in Microsoft Excel to add all values against a single criteria. Let’s take an example, here we have a data table of Sales persons and their sales numbers.