SUMIF VS SUMIFS functions in Excel
In this tutorial you’ll learn how to use the SUMIF VS the SUMIFS functions in Excel. SUMIF is used when you have one condition. SUMIFS is used when you have more than one condition. Excel gives the ability to do calculations using various functions with these conditions using a boolean operator.
For the example I used where we wanted to sum dollar amount of apples using a date range the function argument would look as follows:
**youtube wouldn't let me put in the actual greater than or less than sign so I typed it out. Please change these arguments according to you excel data.**
SUMIFS:
Sum_range: H2:H200
Criteria_range1: F2:F200
Criteria1: "apples"
Criteria_range2: B2:B200
Criteria2: "greater than sign="&M10
Criteria_range3: B2:B200
Criteria3: "less than sign="&N10
SUMIF (one criteria)
Range: F2:F200
Criteria: "apples"
Sum_range: H2:H200
SOFTWARE:
https://melcompton.com/recommends/adobe/
GEAR:
Lenovo ThinkPad Laptop: https://amzn.to/2NvXTGU
Dell Monitors: https://amzn.to/3r0iwte
VIVO Dual Monitor Mount Stand: https://amzn.to/3bBmJ0f
Logitech Wireless Mouse and Keyboard: https://amzn.to/2OX7V4g
Powered USB Hub: https://amzn.to/3bBmCBR
Behringer UM2 Audio Interface: https://amzn.to/3uUWPNE
Audio-Technica Headset: https://amzn.to/2Np3Qpl
WC Wicked Cushions Replacement Earpads: https://amzn.to/3uoihuh
LET’S CONNECT:
Facebook: / therealmelcompton
Twitter: / melissaecompton
LinkedIn: / melissa-compton-17701240
Instagram: / melissaacompton
NOTE: This description contains affiliate links, which means at no additional cost to you, I will receive a small commission if you make a purchase using the links. This helps support the channel and allows me to continue making videos like this. Thank you for your support!
#MsExcel #SUMIF #SUMIFS #Functions