I have been working for over an hour to try and figure out why I am not
getting this formula right. Can someone please see if they can figure out
what I'm doing wrong? Is it my formats maybe? I keep getting 0 or #VALUE!

My data:

A B C D E F G H
id# date code qty amt month/day yr month
C is formatted as text
in F2, formula =right(b2,5) copied down
in G2, formula =left(b2,4) copied down
in H2, formula =left(f2,2) copied down

the date is imported as text.

I need to on another sheet get information summed for specified code, month,
year, and sum column D if all that is true.
So for Jan 2008 code 199000:
=SUMPRODUCT(--(Sheet2!C2:C50000="199000"),--(Sheet2!H2:H50000=1),--(Sheet2!G2:G50000=2008),D2:D50000)

Hope someone can help me, this is so maddening!