 Hey everybody, this is Rod from Burn to Learn and today we'll show you how to use the SUMIF and SUMIFS functions of Excel 2016. Let's say it's time to reorder supplies for your new and successful restaurant. Using SUMIF and SUMIFS will get this tricky process right and help you avoid running out of supplies and losing business next week. Let's first use SUMIF. Here's your inventory report of the ingredients, prices, and the suppliers you use. The SUMIF function sums up the cost of specific supplies you need for the coming week. For example, a box of all dairy products. Write an equal sign and the word SUMIF followed by an open parenthesis. Then select the range in B where all the ingredients you used are listed followed by a comma. Now type an open quotation mark and then describe what you're looking for, which is dairy products. Type a closed quotation mark and a comma. Select the range in D where price values are for each product. Then type a closed parenthesis and press enter. And there's your answer. The cost of all dairy products you need for the next week is $331. Was the explanation of SUMIF helpful? Please let us know in the comments below. Now let's use SUMIFS. The SUMIFS function considers multiple criteria and sorts out situations where one supplier sells more than one kind of product. For example, let's say you want to know the cost of fruits supplied by fruit nutrition, but fruit nutrition also supplies dressing. The SUMIFS function enables you to pinpoint the criteria of your analysis and here's how. Write an equal sign and the word SUMIFS followed by an open parenthesis. Select the range in D where the price values are followed by a comma. Select the range in B where the ingredients are followed by a comma. Type an open quotation mark and then type in what you're looking for, which is fruits. Type a closed quotation mark and a comma. Now select the range in E where your suppliers are. Pinpoint what you're looking for again by typing an open quotation mark and the word fruit nutrition followed by another quotation mark. Now type a closed parenthesis and press enter. And there's the answer. The cost of fruits supplied by fruit nutrition is $178 and the total cost for these supply items is $509. Now you can add the function SUMIF and SUMIFS to your very practical and useful XL 2016 tool chest. If you liked this video, then remember to comment and share it and hit the like button. And do subscribe to our channel for more upcoming videos. Until then, goodbye and thanks for watching.