Excel - Using SUMIF function with two criteria

December 2016



Issue


I want to use the "SUMIF" of Excel for when two criteria are met:

I want to sum column C if column D = "FR" and the column E = "GSA"

Solution


Use this array formula
=SUM((D1:D65535="FR")*(E1:E65535="GSA")*(C1:C65535))

To be validated with CTRL + SHIFT + ENTER.

Thanks to gbinforme for this tip.

Related :

This document entitled « Excel - Using SUMIF function with two criteria » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.