You're missing the argument delimiters and you had an extra set of ( ):

SUMPRODUCT(--('Funding_Sub-Ledger'!$N$5:$N$346=B3),--('Funding_Sub-Ledger'!$O$5:$O$346=C3),--(Aging!$A$3-'Funding_Sub-Ledger'!$I$5:$I$346<=30),--('Funding_Sub-Ledger'!$S$5:$S$3460),'Funding_Sub-Ledger'!$S$5:$S$346)


--
Biff
Microsoft Excel MVP


"BAC" wrote in message
...
I have never been able to get a SumProduct formula to work..

Now I Must Have it but the following is not filtering any of the limits
and
gives me the sum of the entire 'S' column.
B3 and C3 are 3 character text fields. Aging!A3 is a date formatted field
as
is column I on the Funding_Sub-Ledger sheet.

SUMPRODUCT(--('Funding_Sub-Ledger'!$N$5:$N$346=B3)--('Funding_Sub-Ledger'!$O$5:$O$346=C3)--((Aging!$A$3
-'Funding_Sub-Ledger'!$I$5:$I$346)<=30)--('Funding_Sub-Ledger'!$S$5:$S$3460),('Funding_Sub-Ledger'!$S$5:$S$346))

I have tried using '*' in place of '--' as well as all the other formats
presented at:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

I really need help here! As I said I have never gotten SumProduct to work
!!

thanks

BAC