SUMIFS Function with OR Logic in Excel

The Excel SUMIFS function natively handles AND logic only. Typically to achieve OR logic, one would write two SUMIFS functions and add the results together.

In this video, we see how to achieve SUMIFS function OR logic by using a table of values and the super impressive SUM function.

Advanced SUM function examples Power of SUM in Excel | Advanced Sum ...

Learn more than 150 Excel functions - https://amzn.to/3Rg87Go

Timings in the video
00:00 - SUMIFS with multiple conditions
01:02 - SUMIFS to spill results for each condition
02:00 - Adding SUM to SUMIFS function
02:32 - Adding more conditions dynamically
03:21 - Advanced sum function examples

Find more great free tutorials at; https://www.computergaga.com

** Online Excel Courses **
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!
LinkedIn ► LinkedIn: alanmurray-computergaga
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1

#advancedexcelformulas #excel #microsoftexcel

• #howto_style
• #sumifs_function_or_logic
• #sumifs_function_or
• #sumifs_or_logic
• #sumifs_function
• #sumifs_in_excel
• #advanced_sumifs
• #advanced_sum
• #excel_sumif_formula_with_two_conditions
• #sumifs_in_excel_examples
• #sumifs_in_excel_with_multiple_criteria
• #sumifs_excel
• #learn_excel_formulas
• #sumifs_multiple_criteria
• #sumif_function
• #excel_sumifs
• #computergaga
• #alan_murray
• #excel_formulas
• #advanced_excel_formulas
• #sumif_function_in_excel
• #advanced_excel
• #excel_tips
• #excel_for_analysts