I hit post too quickly. There is a third variable.

In addition to Priority and Date in the Detail tab, there is also a status
column. So I need to restate the problem.

For each column I need to count on the detail tab, the number of times the
numbers 1 or 2 appear in Prioirty column when the dates in column B are
03/02/08 and 03/09/08 AND THE STATUS COLUMN is equal to Open, and then I need the count for when the Priority is 3-5 for the same dates.

Priority Date Status
1 02/28/08 Closed
1 03/02/08 Open
5 03/08/08 Pending
2 03/08/08 Open
3 03/08/08 Open
2 03/09/08 Open
2 03/15/08 Open
1 03/15/08 Closed

"bokey" wrote:

I have two worksheets (Summary and Detail) in my workbook.

On the summary tab I have two columns (Priority 1-2) and (Priority 3-5).
For each column I need to count on the detail tab, the number of times the
numbers 1 or 2 appear in Prioirty column when the dates in column B are
03/02/08 and 03/09/08, and then I need the count for when the Priority is 3-5
for the same dates.

Priority Date
1 02/28/08
1 03/02/08
5 03/08/08
2 03/08/08
3 03/08/08
2 03/09/08
2 03/15/08
1 03/15/08