You're very welcome....I'm glad I could help.

--------------------------

Regards,

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

"jcorle" wrote in message
...
THANK YOU THANK YOU! WOOHOO! I have been struggling with this for 2 weeks!

"Ron Coderre" wrote:

Yikes! Typos....(my fingers must be due for a tune-up!)

ALSO...The referenced ranges must all be the SAME SIZE...like this:

=SUMPRODUCT(--(MONTH('2008'!A2:A500)=1),--('2008'!D2:D500="Claims"),'2008'!J2:J500)

or this:
=SUMPRODUCT((MONTH('2008'!A2:A500)=1)*('2008'!D2:D 500="Claims")*'2008'!J2:J500)

Does that help?

--------------------------

Regards,

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



"jcorle" wrote in message
...
with the SumproductY it says #Name? without the Y it says #Value! for
the
first one and #N/A? for the second one.

THanks, though.

"Ron Coderre" wrote:

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