Dcount

P

Paulwilson412

Hi,

I have a spread sheet that I have to enter data into and what I'
trying to do is produce a graph that shows how many new enteries hav
been put in for say last month, so what I need is for a formula t
count up how many rows there are. The trouble is that I cant specif
where the range is as it gets bigger with the more enteries i put in??

Can I use DCOUNT for this, if so can anyone expalin what the database
field, and criteria are as the help file on this doesnt give me an
idea at all?

Thanks for any help you are able to give!

Paul
 
D

Don Guillett

try using a defined name for your graph series
insert>name>define>colA
in the refers to box
=offset($a$1,0,0,counta($a:$a),1)
have a look in HELP index for OFFSET
 
Top