SUMIF with two columns?

[viveleroi0]

I have a SUMIF function that checks column E for a value, and then SUM
column F.

Is there a way to check for two values in two columns?

What I use:

=SUMIF(E1:E4000,"AK",F1:F4000)

What I want"

=SUMIF(D14000,"January",E1:E4000,"AK",F1:F4000)

But that is not valid, is there a way to do this

 

[Domenic]

Hi,

=SUMPRODUCT((D14000="January")*(E1:E4000="AK"),F1:F4000)

Hope this helps