help counting
 

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

help counting
 

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...

"Carla" wrote:

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

help counting
 

Hi,

Assume that your data is in range C5:D9 (including the header row). Suppose
in C5:D5, 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,C11:D12)

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

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