Explainry Tutorials to Expert in IT

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 - 2020 Explainry.com | All Rights Reserved