Learn How to SUM Columns Based on Adjacent Criteria in Microsoft Excel

SUM Columns Based on Adjacent Criteria in Microsoft Excel

The main purpose of this formula is to sum or subtotal columns based on criteria in adjacent columns. Here we will learn how to sum columns based on adjacent criteria. That implies, with the help of a formula based on the SUMPRODUCT function you can sum or subtotal columns based on criteria in adjacent columns. So, with the help of this formula, you can able to sum columns based on adjacent criteria.

General Formula to SUM Columns Based on Adjacent Criteria

=SUMPRODUCT(--(range1=criteria),range2)

The Explanation for the SUM Columns Based on Adjacent Criteria

So we know that with the help of the given formula above you can able to sum or subtotal columns based on criteria in adjacent columns. Here we will learn how to sum columns based on adjacent criteria. As we know that we are using the SUMPRODUCT function to multiply the sum products of two arrays. The first array, array1 is set up to act as a "filter" to allow only values that meet criteria. Array1 uses a range that begins on the first column that contains values that must pass criteria. The criteria are applied as a test that creates an array of TRUE and FALSE values. So, with the help of this formula, you can able to sum or subtotal columns based on criteria in adjacent columns.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel