software

Hi there ~

This is a 2-part query.

PART 1
I need a formula to count the number of entries by month and year, and enter
the count on another summary worksheet. Specifically, Worksheet 1 needs to
show how many cells in Worksheet 2, A:A, have a date that is in Jan-05, how
many Feb-05, etc. See example of Worksheet 1 below.

JAN-05 FEB-05 MAR-05
RECEIVED

PART 2
Then for each month, I need to know how many were assigned to a certain name
(in R:R).

Thanks much!


Try useing quot;Pivot Tablesquot; this is what they are designed to do. It will
take a little trial and error to get the results you want - but once
you understand how they work it is a great tool for what you want to
do. The default is to quot;Sumquot; everything - but you can also select count
- which is what you want to do. Select your Columns - Then put you
quot;Datesquot; in the Row selection then Put your quot;Other Columnquot; in the Column
Part of the Pivot Table and also in the quot;Data Areaquot;
The below is a quick representation of the PIVOT TABLE
It always defaults to a quot;NEW SHEETquot; and after you add new info in your
Table - Just
Count of StatusStatus
DateClosedOpenReceived Grand Total
1/5/200611
1/6/200611
12/5/200611
Grand Total1113--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=498155