Combine Excel SUMIFS with Dropdowns - Excel Formulas Tutorial
Вставка
- Опубліковано 18 сер 2020
- The Excel SUMIFS function allows you to Sum multiple criteria.
For example, you can select one Sales Rep from a list of Sales Reps and select one Region from a list of Regions and return the Sum of those arguments from a Sales list.
Now imagine if we combine this with dropdown lists! Watch it happen in this free Excel tutorial!
--------------------
DOWNLOAD THIS EXCEL WORKBOOK:
Click here to download the Excel workbook & practice over at our blog:
👉 www.myexcelonline.com/wp-cont...
------------
👨🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 Microsoft Excel video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...
Join Now ► www.myexcelonline.com/107-42....
📚 Download Our Free 101 Excel Tips & Tricks E-Book: www.myexcelonline.com/101-exc...
💻 [Free Excel Masterclass] Advance Your Excel Level Within 30 Days: www.myexcelonline.com/107-125...
🔥 OUR BEST EXCEL RESOURCES 🔥
101 Most Popular Formulas E-Book: www.myexcelonline.com/107-58....
101 Ready To Use Macros E-Book: www.myexcelonline.com/107-66....
101 Most Popular Formulas Paperback on Amazon: www.amazon.com/dp/1700300911
101 Ready To Use Macros Paperback on Amazon: www.amazon.com/dp/1700729675
101 Best Excel Tips & Tricks Paperback on Amazon: www.amazon.com/Best-Excel-Tip...
👷 Excel Consulting Services: www.myexcelonline.com/microso...
💻 Looking for more Microsoft Excel tutorials for beginner videos? Check out this playlist: / @myexcelonline
------------
Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)
Cheers,
JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
www.myexcelonline.com/
❤️ Let’s connect on social ❤️
LinkedIn: / johnmichaloudis
Instagram: / myexcelonline
Pinterest: / pins
Facebook: / myexcelonline
Twitter: / myexcelonline
#MyExcelOnline
Hi John.. thanks.. SUMIFS is great.. I use it every day. Thanks for sharing. Thumbs up!!
You are welcome Wayne
OMG this us pure gold! thanks a lot
You're welcome! Thanks for watching!
Pls zoom in so that viewers can see clearly what you're doing. Keep this rolling
Thanks for the feedback.
Really thank for this video, bec I was stuck in my office ..bec of this
So glad it helped!
Great one ....So helpful
Glad you enjoyed it Dhun!
Excellent 👌
Thanks Ram!
Good Example Jhon.
Glad you enjoyed it
What if I need total sale figure from “all” sale Rep with dropdown list function? Thanks
Please check out our blog for more info at www.myexcelonline.com/blog.
Hi John, thanks for the video, what if I select only North from the dropdown without Selecting a sales rep?
Thanks for the question! You could use the same formula, just don't put anything in for Criteria 2. So just get rid of everything after Criteria 1 in the formula on the screen.
How would you modify the formula if you wanted to add an "ALL" categorey to the saleman, qtr or region? So you could see ALL of JOHNs sales regardless of qtr or region?
Thanks for the question! You could start with an IF statement that would do a SUM if the category was all and then a SUMIF if the value was anything besides All. Something like this (say the dropdown is in cell A2): IF(A2="All",SUM(sum range),SUMIF(sumif criteria)). Hope that helps!
Please zoom in for better understanding
Thanks. We will consider that for future videos!
What if you’re doing exactly this, but adding numbers across multiple tabs? Trying to SUMIF for server tips for the week (each day is a different tab) using a drop-down of names on a “totals” page.
When typing the formula, try holding down control while you select cells on other tabs.