Vince,

It doesn't look like you have a "Lenght" argument for your RIGHT() function
for column G...

--(RIGHT(Requisitions!$G$7:Requisitions!$G$1015)=610 06)

....should be...

--(RIGHT(Requisitions!$G$7:Requisitions!$G$1015,5)=6 1006)

....although, I'm not sure if you can take the 5 right characters of a range
of cells and compare them to a specific value. Let me know if it works out.

OH!!! I just noticed something else. I'm assuming column G is text...well
the RIGHT() function returns text anywas. You are trying to compare text to
a numeric value. I'm not sure if that will work either. So...your original
portion of the formula for column G...

--(RIGHT(Requisitions!$G$7:Requisitions!$G$1015)=610 06)

....might have to look like this...

--(RIGHT(Requisitions!$G$7:Requisitions!$G$1015,5)=" 61006")

HTH,

Conan Kelly





"Vince" wrote in message
...
The following formula returns 0.

=SUMPRODUCT(--(YEAR(Requisitions!$C$7:Requisitions!$C$1015)=2009 ),--((Requisitions!$H$7:$H$1015)=RIGHT(A3,5)),--(RIGHT(Requisitions!$G$7:Requisitions!$G$1015)=610 06),Requisitions!$F$7:$F$1015)

C F G H

6/29/2009 $29,466.00 41-70-80801-61006 80801
6/29/2009 $2,080.00 41-70-80801-61006 80806
6/29/2009 $8,840.00 41-70-80801-61006 80801
6/30/2009 $1,061.16 41-70-80801-61006 80804
7/1/2009 $4,433.90 41-70-80801-61006 80801
7/6/2009 $20,000.00 41-70-80801-61006 80801

The following works well with the 3rd variable of column (G) not being
used

=SUMPRODUCT(--(YEAR(Requisitions!$C$7:Requisitions!$C$1015)=2009 ),--((Requisitions!$H$7:$H$1015)=RIGHT(A3,5)),Requisit ions!$F$7:$F$1015)

Your help is appreciated.