Hello,

I am using this formula
=SUMPRODUCT(--(MONTH(Gateway!B3:B26)=1),--(YEAR(Gateway!B3:B26)=2005),--(ISNUMBER(Gateway!B3:B26)))which
works fine. Based on this formula how can I sum the dollar value in column J
for the month of January? Your help is appreciated.

Mark