The sumif function in Microsoft Excel is a versatile tool to calculate the total of items based on a specific condition. In the earlier videos we learnt about the ‘sum’ or ‘autosum’ feature which adds the data containing numbers.
So how is sumif used? Let’s say you have a number of employees in your company. You now wish to know the total salary that you pay your managers. Under standard circumstances without the knowledge of the sumif feature you would filter the data containing the designation manager and then total their salaries. With the sumif function you can add the salaries of the mangers directly:
=sumif(C4:D12, “Manager”, D4:D12) where the worksheet range C4:D12 contains the designations in the C column and the salaries in the D column. “Manager” is the criterion and the data to be summed is in D column (salaries) as shown in the image below:
Often the function is used in hotels and restaurants where they have sales items which may have a VAT (Value Added Tax) and some items don’t need to be taxed like bread. You may now need to calculate totals of items which have a VAT and present the VAT values either to the customer or sales tax authorities.
Sometimes we may need to add only sales above 200000 in a quarter for a performance evaluation and we do not wish to take smaller sales amounts into consideration. Here we can use this sumif method to perform such calculations.
In short, the sumif function in MS Excel is a simple and powerful method to calculate totals based on a condition.
Watch the training video: