Excel - Using SUMIF function with two criteria

December 2016


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"


Use this array formula

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.