| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing data between two date criteria
=SUMPRODUCT(--(I6:I250<DATE(2009,1,1)),--(ISNUMBER(I6:I250)),J6:J250)
I am using this formula to calcuate the number of square footage with an expiration date less than 1/1/09 (some of the cells contain the value "month-to-month"). I now need to write this same formula for expiration dates between 1/1/09 and 6/30/09. How do I get multiple date parameters - I keep getting errors trying to use the AND function. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Criteria Summing | Excel Worksheet Functions | |||
| Summing/Counting Data in One Column Based on Criteria Another Col | Excel Worksheet Functions | |||
| Summing Data by date from different tables | Excel Worksheet Functions | |||
| summing values in a data table based on criteria in another column | Excel Worksheet Functions | |||
| Summing data based on criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
