Glad to hear you got it working - thanks for feeding back.

Pete


On Aug 28, 7:48*pm, Tasha wrote:
I figured it out....thank you though.

I set the query that I used to build the file to break out the month/year
from the date. *Imported the file to Excel, then set up #'s above the month
fields for year and month by typing in 1-12 for month and 8, then 9 for each
year. *I referred back to these fields in my sumproduct formulas, and I took
the quotes out from around 199000, and it gave me my total. *:) *



"Pete_UK" wrote:
Those left and right formulae will be returning text values, so yo wil
have to put quotes around the numbers like this:

=SUMPRODUCT(--(Sheet2!C2:C50000="199000"),--(Sheet2!H2:H50000="01"),--
(Sheet2!*G2:G50000="2008"),D2:D50000)

Hope this helps.

Pete

On Aug 27, 10:21 pm, Tasha wrote:
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!- Hide quoted text -

- Show quoted text -