Find the aggregate value using SUMIFS with DYNAMIC ARRAYS in Excel

Use SUMIFS to add values based on one or more conditions. SUMIF can add values based on only one condition, whereas SUMIFS provides you the flexibility to add based on one or multiple conditions, thus making it the preferred choice.

This video shows you how to add values using SUMIFS with dynamic arrays.

Dynamic arrays work with Excel 365. Microsoft added them to one time licenses from Excel 2021.

▶️ Other videos that may interest you
For a detailed explanation of SUMIFS, please see our full video

Introduction to dynamic arrays

✅ Subscribe to our Channel to level up your Excel skills faster

⬇️ Download the file used in the video

💻 Courses offered by us

Learn more about our Excel Masterclass course

Explore all courses

📘 Download our E-Book on Excel Shortcuts (Windows and Mac)

🗂️ Access all our templates and E-Books

🤝 Connect with us