You can do this with a pivot table.

Data=Pivot Table
After setting up the pivot table, select the date field and group on Month.

See Debra Dalgleish's site (Look under P )

http://www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvy


"Question on Conditonal Countif" <Question on Conditonal
wrote in message
...
Hi,

I have a huge data base in which the first column is a date. The following
comuns have non-numercial data that I need to count in a monthly basis.
For example, column B could be either "W", "S", or "B"; I need to know how
many "W", "S", and "B" are in January, February, and so forth.

I tried to use an embedded IF clause, but did not work.

Thanks for you help

Suzanne,