Try something like this:

=SUMPRODUCTY(--(MONTH('2008'!A2:A500)=1),--('2008'!D2:D173="Claims"),'2008'!J66:J82)

or this:
=SUMPRODUCTY((MONTH('2008'!A2:A500)=1)*('2008'!D2: D173="Claims")*'2008'!J66:J82)

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"jcorle" wrote in message
...
Good Afternoon...

I have come up with this formula
=IF(AND((MONTH('2008'!A2:A500)=1),('2008'!D2:D173= "Claims")),SUM('2008'!J66:J82),0)

However, the formula only brings up "$0.00" instead of the 17 million or
so
it should upon proper calculation... HELP!

Thanks ahead of time!
Jen