Adding Mulitple Criteria in a Single Column

August 9, 2015
Marcus Small

Creating a sum where the criteria is in the same column has usually been about creating a sumif or sumifs and adding multiple iterations together. This turns formula which intuitively should be short into long, difficult to read formulations. With the intelligent use of Sumproduct you can use one formula to capture multiple criteria in the same column. Here is an example.

Tags Excel, Sum, Multiple, same column