| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT dates in ColumnY based on numbers in ColumnX
I need to count the number of dates in column Y based on whether or not a
number is entered in column X. I've tried several varieties of the COUNT functions and keep getting errors. Here is scenario: if columnX contains "1" in any of the cells, I need the function to count the number of dates in columnY that correspond to those cells from columnX with the number 1. Thanks, M.Moncrief |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sum up or count based on dates | New Users to Excel | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| Unique numbers if between dates | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Threaded Mode
