Combine Excel SUMIFS with Dropdowns - Excel Formulas Tutorial

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:

------------

👨‍🏫 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...

🔥 OUR BEST EXCEL RESOURCES 🔥

------------

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

❤️ Let’s connect on social ❤️

#MyExcelOnline

[wayneedmondson]

Hi John.. thanks.. SUMIFS is great.. I use it every day. Thanks for sharing. Thumbs up!!

[mancoey]

What if I need total sale figure from “all” sale Rep with dropdown list function? Thanks

[apn]

Pls zoom in so that viewers can see clearly what you're doing. Keep this rolling

[JobelynTan]

Is it possible to sum 2 out of 3 filters only? making it like dynamic filters?what will be the formula?

[hashanmfernando]

Hi John, thanks for the video, what if I select only North from the dropdown without Selecting a sales rep?

[prasoonkp]

Really thank for this video, bec I was stuck in my office ..bec of this

[joemadden]

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?

[rajandogra]

What to do if we want to see everyone data with sumifs? I mean if somehow we can add "All" in dropdowns?

[arifjagmag]

Please zoom in for better understanding

[nsamples]

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.