Sum against one criteria in multiple columns

The SUMPRODUCT function is used to sum values against one criteria in multiple columns. Follow these steps to perform the function.

1– Select a blank cell and type the SUMPRODUCT function.

 

2– Against array1 in the function, set criteria from product column.

 

3– Select cells from column Jan and Feb, B4:C8 to sum against criteria.

 

4– After pressing Enter, Excel will sum all cells against the criteria B.

 

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved