Sumifs Function

If you are looking for an easy and yet useful function that can Sum data based on multiple conditions, then look no further than the Sumifs function. Assuming that you want to calculate the total sales figure for a given month and region the Sumifs function can be used to produce the desired results. In the example below we explain how, exactly, that can be done. (Calculating Total January Sales For The East Coast)

Applies To: Excel 2007, 2010

1.         For this tip-the screen shot below will be used as an example

2.         Select cell C19 then as below

3.         Enter as per screen shot below and select OK

The total January Sales for the East Coast is $46,000.00. The result has been achieved with relative ease and up to 127 range/criteria pairs are allowed.

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email enablement@alchemex.com and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations

Further Reading:

1. SUMIFS Function
2. Small Function
3. MAX function
4. REPT Function
5. SUM function