dget or dsum, that is the question
 

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

dget or dsum, that is the question
 

Maybe just use Countif:
=COUNTIF(C2:C50,"<7")

Hope this helps
Rowan

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

dget or dsum, that is the question
 

I used dcount and my criteria was ="<7"

worked fine for me.

--
Regards,
Tom Ogilvy

"justaguyfromky" wrote in message
...
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