Sumproduct Function with Multiple Columns

In this article, you will learn how to use SUMPRODUCT function with multiple columns. If you have data that contains multiple columns & you want to add the numbers stored in these columns based on the condition (say a code or so).

Let us learn how to use Sumproduct function for adding values in multiple columns.

Following is the snapshot data we have:

 
img1

 

  • In cell I2, the formula is =SUMPRODUCT((A:A=”ABC”)*B:F)

 
img2

 

  • Sumproduct function is checking the code in column A if found equals to “ABC” then the values will be added for that row.
  • Cell A2 does not contain the code hence the values in range B2:F2 will not be added
  • In case we change the code in cell A2 to “ABC” then the result be updated automatically.

 

img3

 

In this way, we can use SUMPRODUCT function to add the sum based on the criteria.

 

xlsx-1567

Download – SUMIFS function with Comparison Operator – xlsx

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube