Slicing Data based on Multiple Criteria with SumProduct()

January 28, 2011 by 1 Comment

Excel’s SUMIF() Formula is a great tool.  It allows you to sum a column based on specific criteria (from another column).  But what if you want information filtered based on two (or more) criteria?

Enter SUMPRODUCT(). Read more of this post

Filed under Application (Excel, Access) and Process Development, Business Stuff Tagged with , , , ,