I have never been able to get a SumProduct formula to work..Help!

B

BAC

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$346>0),('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
 
T

T. Valko

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$346>0),'Funding_Sub-Ledger'!$S$5:$S$346)
 
B

BAC

Thanks, but that didn't work either. I get 0 for the results when I KNW it
should be over 12.5MM

BAC
 
T

T. Valko

Ok, then tell us what's in every one of your referenced ranges.

What's in:

'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
'Funding_Sub-Ledger'!$S$5:$S$346

Are there negative numbers in 'Funding_Sub-Ledger'!$S$5:$S$346 ?
 
B

BAC

Thanks for you follow up, but my boss came over and re-formatted all the
columns (which i thought I had already done), and your earlier response
formula just started popping up answers!

thanks again

BAC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top