SUMPRODUCT

A

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.
 
D

Domenic

Hi Amy,

Try,

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

Hope this helps!
 
P

Paulw2k

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

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
 
A

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:...





.
Click to expand...
 
D

Dave Peterson

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