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.