View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bokey bokey is offline
external usenet poster
 
Posts: 10
Default count if column A is 1-2 and column B is 03/02/08 to 03/09/08

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