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 | All Rights Reserved