JoeU2004 - Thanks for the help. It was the quotes and the argument was
missing! Can't beleive I did not see that...looked at formula way to long I
guess (forest for the trees!). I did copy and paste into the post by the
way..

"JoeU2004" wrote:

"Vince" wrote:
The following formula returns 0.
[....]
The following works well with the 3rd variable of column (G) not being
used

You need quotes around "61006" in the 3rd argument testing column G. Also,
you are missing an paramenter in the RIGHT function in that 3rd argument;
but I presume that is merely a typo in the posting. Anyway, it should be
(correcting another syntax error):

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

Note: In the future, it is best to copy-and-paste formulas into postings,
rather than retype them, especially when the question is about syntax or why
the elements of a formula do not work as intended. GIGO.


----- original message -----

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