Рет қаралды 14,511
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:
States are listed in column A, Cities are listed in column B, and Purchase amount in column C.
To find the total purchases by State and by a specific city in column B, use SUMIFS. An example of the formula would be =SUMIFS(C2:C12, A1:A12. "GA", B1:B12, "Atlanta") would find all purchases for Atlanta, GA customers.
With the SUMIFS function, the sum range comes first. Followed by criteria. The criteria has two arguments, the criteria range and then the criteria.
Chris Menard's Website:
chrismenardtra...
Upcoming MBA events in Excel:
October 5, 2019 - Chris Menard trains the Executive MBA students at the Terry College of Business in Atlanta, GA in Excel.
chrismenardtra...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ KZbin keyword search - TubeBuddy - www.tubebuddy....
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!