Sumifs Excel Tutorial With Multiple Criteria In Different Columns
SumIf enables you to query tabular data in Excel by providing one criteria example (query by example).
Excel 2019 Bible: https://amzn.to/2ZLkmBE
Excel Power Programming: https://amzn.to/35hzFDh
This sumifs tutorial shows you how to use sumifs with multiple criteria in different columns and explains the difference between sumif and sumifs.
The Sumif function takes three arguments, the first being the range that contains the criteria, the second argument is the actual criteria and the third argument is the range to be summed.
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson
☕
If you need to do a semi complex query containing more than one criteria, i.e where you are drilling down on the criteria then you need to use the sumifs function.
The sumifs function allows you to sum an Excel data range using several "and" criteria.
Sumifs takes a minimum of three criteria, followed by optional range and criteria pairs.
In this tutorial I also cover the counta function to create a dynamic range by summing non blank cells and the indirect function to create a more easily adjusted sumifs function criteria.
I also cover the subtotal function which is used to adjust the result when a filter is applied on an excel autofilter.
Video Production
===============
Sony Camera: https://amzn.to/3mqyqfu
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum
Microphones
---------------
Screen Casting: https://amzn.to/3a2TnHN
Microphone and Arm : https://amzn.to/3iwvL2S
Talking To Camera: https://amzn.to/3FqXI6b
Video Kit
-------------
Lights
Elgato video Lights: https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh
Note Taking
--------------
Rocketbook reusable notebook https://amzn.to/3sSK3xg
#msexcel
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
