| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Totalling by referring to 2 date ranges
I have a spreadsheet that has 2 columns of date ranges.
I want to refer to the first column and count how many entries meet a specific date range criteria. If there is no entry in the first column, I want to refer to column 2 to see if the range matches. Can somebody help???? Thanks |
|
#2
|
|||
|
|||
|
Try:
=SUMPRODUCT((A1:A100=D1)*(A1:A100<=E1)+(A1:A100=" ")* (B1:B100=D1)*(B1:B100<=E1)) where D1 = start date, E1 = end date. HTH Jason Atlanta, GA -----Original Message----- I have a spreadsheet that has 2 columns of date ranges. I want to refer to the first column and count how many entries meet a specific date range criteria. If there is no entry in the first column, I want to refer to column 2 to see if the range matches. Can somebody help???? Thanks . |
|
#3
|
|||
|
|||
|
perfect! thanks for the help!
"Jason Morin" wrote: Try: =SUMPRODUCT((A1:A100=D1)*(A1:A100<=E1)+(A1:A100=" ")* (B1:B100=D1)*(B1:B100<=E1)) where D1 = start date, E1 = end date. HTH Jason Atlanta, GA -----Original Message----- I have a spreadsheet that has 2 columns of date ranges. I want to refer to the first column and count how many entries meet a specific date range criteria. If there is no entry in the first column, I want to refer to column 2 to see if the range matches. Can somebody help???? Thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totalling by referring to 2 date ranges | Excel Discussion (Misc queries) | |||
| Date Math Problem | Excel Worksheet Functions | |||
| date and time | New Users to Excel | |||
| sum of date ranges | Excel Worksheet Functions | |||
| calculating date time ranges | Excel Worksheet Functions | |||
Linear Mode
