N
Neal
I currently use the following DSUM function:
=DSUM('New Application Decision Summar'!$A$5:$P$686,'New
Application Decision Summar'!D$5,'MTD Application Summary'!
$A$116:$C117
Month Credit Analyst Decision Decision Amount Count are
the column headings, but I also have a column heading
decison date and this is the date I need to sum by.
I am familiar with the DSUM function, as row A has column
headers to locate, but the problem I am having is that I
need to do a sum based upon the decision date such as
Is there an IF statement I can insert to help me this? Or
do I need another formula?
This board is terrific. Thanks to all who help.
=DSUM('New Application Decision Summar'!$A$5:$P$686,'New
Application Decision Summar'!D$5,'MTD Application Summary'!
$A$116:$C117
Month Credit Analyst Decision Decision Amount Count are
the column headings, but I also have a column heading
decison date and this is the date I need to sum by.
I am familiar with the DSUM function, as row A has column
headers to locate, but the problem I am having is that I
need to do a sum based upon the decision date such as
=08/01/2003 and <08/31/2003.
Is there an IF statement I can insert to help me this? Or
do I need another formula?
This board is terrific. Thanks to all who help.