SUMPRODUCT

[Amy]

I appreciate all the help, but I simply cannot get this to
work. This is how I have the formula typed:

=SUMPRODUCT((MONTH(UPS!G5:G900)=10),(YEAR(UPS!G5:G900)
=2003),UPS!H5:H900)

I am getting the #VALUE! error.

 

[Jason Morin]

Try replacing the "," in the formula with "*".

HTH
Jason
Atlanta, GA

 

[Domenic]

Hi Amy,

Try,

=SUMPRODUCT(--(MONTH(UPS!G5:G900)=10),--(YEAR(UPS!G5:G900)=2003),UPS!H5:H
900)

Hope this helps!

 

[Paulw2k]

=SUMPRODUCT((UPS!G5:G900=10)*(UPS!G5:G900=2003)*(UPS!H5:H900))
if Row 5 is the header row, use G6:..., H6:...

 

[Amy]

OK, I now have the following formula which works until I
try to increase my range. I need the range to be from 5
to 900.

=SUMPRODUCT(((MONTH(UPS!G5:G357)=10)*((YEAR(UPS!G5:G357)
=2003)*(UPS!H5:H357))))

Any suggestions?

Thanks! Amy

 

[Amy]

No, for some reason I'm getting the #VALUE! error with
this formula.

Amy

 

[Amy]

No, this formula gives me a result of 0.

Amy

-----Original Message-----
=SUMPRODUCT((UPS!G5:G900=10)*(UPS!G5:G900=2003)*(UPS! H5:H900))
if Row 5 is the header row, use G6:..., H6:...





.

 

[Dave Peterson]

You may want to look at your data and verify that you have real dates where you
want real dates.