SUMPRODUCT is not returning required value

[Sean15]

Hello:

I have a pivot table with Jan...Dec in A6 to A13 and Sum of Amounts in D6 to D13.

I want the add sum of amount for Jan, Feb and Mar in I9. The formula below is returning zero.

=SUMPRODUCT(($A$6:$A$13="Jan")*($A$6:$A$13="Feb")*($A$6:$A$13="Mar")*($D$6:$D$13))

Could you help me fix formula?

Thank you

Sean

 

[Joe4]

You are welcome.

Note, I just modified jtkaw's fine formula (so I don't take credit for coming up with the formula, just editing it!)