conditional sum 2007 help please
 

I have a table of customers items due dates etc and want to use the
conditional sum wizard to sum by account number (Column A, Table5) to sum the
overdue value by no days overdue, this works fine if I enter the account
number in the formula but I would like to enter this account number in a cell
eg A2 so that i do not have to keep changing the formula. Any help would be
greatly appreciated. Thanks

Not working
=SUM(IF($A$20:$A$20000="A2",IF($L$20:$L$20000=1,I F($L$20:$L$20000<=30,$G$20:$G$20000,0),0),0))

Working formula
=SUM(IF($A$20:$A$20000="300099999",IF($L$20:$L$200 00=1,IF($L$20:$L$20000<=30,$G$20:$G$20000,0),0),0 ))

conditional sum 2007 help please
 

If you point to a cell, there should be no double quotes,
use it as eg: ... =A2, not ="A2"

If ... =A2 doesn't work here due to your source data being text nums while
the num entered in A2 is a real num, just try it like this: .. =A2&""
The &"" will convert the real num in A2 to a text num for correct matching
within the expresssion
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Rich" wrote:
I have a table of customers items due dates etc and want to use the
conditional sum wizard to sum by account number (Column A, Table5) to sum the
overdue value by no days overdue, this works fine if I enter the account
number in the formula but I would like to enter this account number in a cell
eg A2 so that i do not have to keep changing the formula. Any help would be
greatly appreciated. Thanks

Not working
=SUM(IF($A$20:$A$20000="A2",IF($L$20:$L$20000=1,I F($L$20:$L$20000<=30,$G$20:$G$20000,0),0),0))

Working formula
=SUM(IF($A$20:$A$20000="300099999",IF($L$20:$L$200 00=1,IF($L$20:$L$20000<=30,$G$20:$G$20000,0),0),0 ))