Help with SumIf with two conditions

Hi again.

Here's another way

=SUMPRODUCT(--($A$2:$A$1000>=DATEVALUE("01/01/2007"))*($A$2:$A$1000<=DATEVALUE("31/01/2007"))*($C$2:$C$1000="Gas")*($B$2:$B$1000))

VBA Noob