Free Online Tutorials on Spreadsheets

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