Dates and Dsum function

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
=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.
 

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