SUMIFS Function in Excel

Posted on:  08/25/2019
SUMIFS Function in Excel
The SumIfs Function is an awesome Excel function. It came out with Excel 2007. It is superior to the Sumif function. The Sumif function only allows one criterion. The Sumifs function allows 29 criteria. In this video I look at referencing cells with Sumifs, using operators with sumifs.
 
 

Examples of SUMIFS:

 
What are the purchases for Atlanta, GA?
 
States are listed in column E, Cities are listed in column F, and Purchase are shown in column D. 
To find the total purchases by Atlanta GA use SUMIFS. The formula would be
 
=SUMIFS(D2:D18, E2:E18. "GA", F2:F18,"Atlanta, "Atlanta")
 
This would find purchases for Atlanta, GA customers. The SUMIFS function requires the purchases or values, followed by the criteria range and critera. The first criteria range is States with "GA" in quotes. The second criteria range is CITY with "Atlanta" in quotes.
 

YouTube Video on SUMIFS

 
Chris Menard

Chris Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.

Categories