Excel Formulas to Lookup Table Based on Multiple Criteria with SUMIFS

So far we have learned how to sum the values with SUMIFS. In this guide, we are going to learn the simple steps used to lookup the table based on the multiple criteria in Excel by using the SUMIFS function. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

• Use the below formula to look up the table with multiple criteria.

=SUMIFS(table[values],table[column1],c1,table[column2],c2,table[column3],c3)

Syntax Explanations:

• SUMIFS – In Excel, the SUMIFS function will help to sum the values in the cells that meet multiple conditions or criteria.
• Table – It represents the input table from your worksheet.
• Values – It contains the values where the lookup value present.
• Column – It represents the input data.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image. Here we will show how to look up a table based on multiple criteria.

• First, we will create a table based on the input values.

• Then, apply the above-given formula to the formula bar section and press the ENTER key.

• Finally, we will get the result in the selected cell.

Closure:

From this short tutorial, we have described the simple formula used to lookup the table based on multiple criteria with the SUMIFS function. If you have any doubts , feel free to share them with us. We will assist you. Continue learning on Geek Excel!! *and Excel Formulas *!!

Read Ahead:

• Excel Formulas: Multi-criteria Lookup and Transpose!!
• Excel Formulas to Sum the Values Between Two Dates!!