LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count number of cells and total in one column, based on another column suffix Pierre Excel Worksheet Functions 5 October 31st 07 12:28 AM
Count entries in one column based on values in another column Kurt Excel Worksheet Functions 7 January 10th 07 09:29 PM
how to count a column based on condition of another column R Khoshravan Excel Worksheet Functions 4 August 31st 06 05:25 PM
SUM/COUNT column(s) based on specific value present within the column markx Excel Worksheet Functions 6 March 22nd 05 10:23 AM
Can I count values in column 1 if criteria in column 2 are met confounded office user Excel Worksheet Functions 2 November 9th 04 12:02 PM


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"