sumif function..

[OAKLEYS21]

Can someone tell me why this formula doesn't work?
=Sum(IIf([AccountName],"CURRENT PORTION - INV LEASES",[DepositAmount]))

Thanks

 

[SkipVought]

O,

Your formula needs an EXPERSSION that will return TRUE or FALSE...
[tt]
=Sum(IIf([AccountName],"CURRENT PORTION - INV LEASES",[DepositAmount]))
[/tt]

like...
[tt]
=Sum(IIf([AccountName]="Some Account Name","CURRENT PORTION - INV LEASES",[DepositAmount]))
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[OAKLEYS21]

Still didn't work?? what I want to do is total the values in the accounts with the same name. Any other ideas? thanks.

 

[SkipVought]

[tt]
Select AccountName, Sum(DepositAmount])
From MyTable
Group By AccountName
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244