Sumif with 2 criteria matching month

Re: Sumif with 2 criteria matching month

Hi

Use the following formula.

=SUMPRODUCT(--(MONTH($D$6:$D$23)=MONTH(I$16))*($C$6:$C$23=$H17),$E$6:$E$23)

Now the bit you need to pay real attention to. You need to change your dates in Row 16 to actual dates. I have tested the above and it works nicely provided you follow the instructions.

Take care

Smallman

Re: Sumif with 2 criteria matching month

Hi skamat

Alternatively use the TEXT function within the SUMPRODUCT, in I17, copy across & down:

=SUMPRODUCT(--(TEXT($D$6:$D$23,"mmm")=I$16),--($C$6:$C$23=$H17),$E$6:$E$23)

Re: Sumif with 2 criteria matching month

Why not use a PivotTable? Dates can be grouped as months.