dsum with date criteria

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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?
 
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.
 
Back
Top