The criteria isn't supposed to be a single value or criterion, but rather a
range of cells that specify the criteria. In this case, it would just need
to reference two cells (one column, two rows). The first cell should contain
the exact same heading as the heading on the column that shows how many days
till the appointment; the second would be <7. (FYI 'field' in the DSUM
indicates the field in the database which is being totaled, not the field to
which the criteria apply; hence the need for the separate criteria range).


"justaguyfromky" wrote:

I want to add a reminder line to my excel workpage. I have a list of dates
that I have certain appointments, also I have a countdown of the number of
days until that appointment. All of this data is already in a table. What I
need it to do is to count the number of appointments I have in the next 7
days. When using the dget or the dsum, I get an error #VALUE

Database: SST (name of the range the database is in)
Field: 3
Criteria: <7

In the criteria line, it wants text, I dont understand why it wont take a
number when a number is what I am looking for.

Any help would be appreciated