help counting

[Carla]

I have an excel 2007 spreadsheet. It contains a column called lastname
and a column called Class Dates. I want to count the lastnames for a
particular class period. For example count the lastnames for the class date
Oct.19th-Nov.12th

I tried counif but it keeps returning a zero. The dates are text they are
not formatted as dates.

If possible I would like to have the user prompted for a date range with a
message box and then have it count the last names that meet that criteria.

Any help is greatly appreciated

Thanks

 

[Sherry]

Hi Carla,
When I enter the criteria, I use the wildcard like this "*" and then it
counts every line in the range I've selected...

 

[Ashish Mathur]

Hi,

Assume that your data is in range C59 (including the header row). Suppose
in C55, you have Date and Last Name. In C11:E11, type Date, Date and last
Name. In C12, type >=1/1/2009 and in D12, type <=31/3/2009. In E12, type
=DCOUNTA($C$5:$D$9,E11,C1112)

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com