We consider the SUMIFS function for multiple conditional summation as one of the most important Excel functions, as it enables you to obtain the sum of a specific Range or field with more than one condition, but when the SUMIFS function is used in Excel with the INDEX function, it turns into the most powerful Excel equations because adding the INDEX function to the SUMIFS function gives you the ability to obtain a variable or dynamic Sum Range. In this video, we will explain how to use the SUMIFS function with the INDEX function in the Excel sheet to obtain a dynamic sum range. To download the work file: https://bit.ly/39zGp1w Previous videos Dynamic Variance Chart in Excel • How to create a professional chart for the percentage of change in... Index function and its use in creating lists of names and drop-down lists (Drop Down List) • Dynamic drop-down lists in Excel... Choose function - Multiple choice function in Excel Choose Function in Excel • Choose Function - Multiple Selection Function... DGET Function is one of the most powerful lookup functions in Excel DGET Function in Excel • DGET Function is one of the most powerful lookup functions in Excel... Explanation of using the Hlookup function with Match in Excel How to use Hlookup with Match in Excel • Explanation of the horizontal lookup function HLOOKUP in Excel Explanation of the Slicer tool Advanced filter tool in Excel • Explanation of the Slicer tool Advanced filter tool... Detailed explanation of the survey chart in Excel How to create a survey chart in excel • How to draw a graph for a survey ... Function to calculate the number of days in a month in Excel Excel Function to Count Days in each Month • Function to calculate the number of days in a month in Excel ... Explanation of the TRIM function and how to use it with the VLOOKUP function • Explanation of the TRIM function and how to use it with the D... Text Function in Excel Function to convert numeric values ​​in Excel • Text Function in Excel Function to convert ... Cell Reference In Excel Explanation of reference cells in Excel • Learn how to fix a cell in Excel while writing... Consolidation Merging and grouping data in more than one sheet in Excel • Consolidation Merging and grouping data ... Protect Worksheet Protect a worksheet in Excel • How to protect a worksheet in Excel Exce... Subtotal Subtotal tool in Excel - Excel Online • Subtotal Subtotal tool in the ... Advanced features and advantages of tables in Excel Excel Online • The importance of using Excel tables dynamically... Features and advantages of tables in Excel Tables Features in Excel • The most important features of tables in Excel ... Using CountIF while excluding a value Use CountIF Except a Value • Using CountIF while excluding a value ... Function Today in Excel and its use to find out the days remaining until a specific date • Function Today in Excel and its use ... A simple explanation of dealing with large data and making a summary of it by using pivot tables Pivot Tables • Pivot Tables Explanation... Explanation of Advanced Filter in Excel Advanced Filter • Advanced Filter in Excel Explanation of the tool... A simple way to select and delete empty rows How to delete the Empty Rows Excel Online • The fastest way to select and delete empty rows... Search with multiple criteria in Excel tables Lookup with multiple Criteria in Excel Tables Excel Online • Use the vlookup function to search with more than one... Prevent Values ​​Duplication in Selected Column • Prevent duplication of data in Excel Exce... How to select different cells in a column and row Select the Different Cells In Columns and Rows • How to select different cells from the column... Editing more than one Excel Sheet At the same time - Apply Action on Multiple Sheets at the same time • Editing more than one Excel Sheet In... Practical explanation of how to design Infographic Charts On Excel - Excel Online • How to draw a chart Infographic Ch... Explanation of the tool to divide cell contents in Excel Text to Column Practical explanation - Excel Online • Explanation of text to columns in Excel how t... Drop-down list tool Data Validation List Explanation of entering list data https://bit.ly/2WAj1Mj Copy Formulas between Tables in Excel trick without any changes Copy Formulas between Tables in Excel https://bit.ly/32Vu4SQ The compound IF function and how to use it with the OR - AND function in Excel with practical explanation Excel Online https://bit.ly/2MHZLta Building dynamic drop-down lists using the OFFSET function and how to link more than one list https://bit.ly/31yZPPP Explanation of the IF Error function in Excel with its use to show more than one result - with practical explanation https://bit.ly/2MJaG4v Flash Fill Magic Quick Fill Tool and How to Use It to Repeat a Cell Pattern - Practical Explanation https://bit.ly/2pcC42S Types of errors in Excel and how to solve them with a practical