| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting dates <= 7 days ago based on criteria in a diff column
I have a spreadsheet that holds all tasks for a project. Column D holds a
catagory and column Q holds the date closed. I need a formula (on a separate sheet) that counts all tasks of a specific category that were closed in the past 7 days. I already have a formula that calculates all tasks that were closed in the past 7 days, just need to add the additional criterion of the category. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting information in one column based on criteria in another co | New Users to Excel | |||
| Counting items in one column based on criteria in another | Excel Worksheet Functions | |||
| Counting dates based on certain criteria | Excel Worksheet Functions | |||
| Counting unique dates based on selected criteria in a list | Excel Worksheet Functions | |||
| Counting & Summing based on criteria on another column | Excel Discussion (Misc queries) | |||
Threaded Mode
