dsum with date criteria

G

Guest

Hi everybody,

I am working with Excel XP.

I have a database with 2000 records and dbase formulas (mainly dsum) to
calculate
results in date ranges. The problem I have comes from the date criteria. As
I neeed to change regularely the dates, I tried to insert a formula in the
date criterion field, but without any success . The formula should look like
: > 8/1/2003 but I cannot make it work as > is not a numerical factor.

Could somebody help me ?
Thanks in advance

Michel from Belgium
 
A

Aladin Akyurek

Let E1:E2 be the criteria range with:

E1 housing Date as the relevant label.

In E2 enter:

=">"&J1

where J1 houses a date that you want to invoke as the date criterion, which
you can replace with any date at will..

A DSum formula like:

=DSUM(A1:B15,2,E1:E2)

would calculate the desired sum.

Is this what you wanted to do?
 
G

Guest

I had the same problem as Michel, and found your post most helpful. Where did
you find this information? I could not find it in Excel help, nor could I
find it in the five or six Excel manuals that I consulted.
Thank you.
 

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