SumProduct not working Reason?

[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

 

[Tom [Pepper] Willett]

This would be a question for an Excel newsgroup, not FrontPage.
--
===
Tom [Pepper] Willett
Microsoft MVP - FrontPage
"You're a daisy if you do!"
---
FrontPage Support:
http://www.frontpagemvps.com/
===
|
| 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

 

[Andrew Murray]

Frontpage can't add up figures; try the Excel group.