| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a "SUMIF" based upon a Date Range?
Column A represents the "Date" of an occurence.
Column B represents the "Cost" of each occurance. There are 1,441 rows. I want to know what the Cost is for a specific date range, the month of December 2007 (i.e. =12/01/2007 and <=12/31/2007). Any suggestion will be appreciated. ~SRacak |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a "SUMIF" based upon a Date Range?
Hi,
Where C1 & C2 contain the lower and upper date range =SUMPRODUCT((A1:A1441=C1)*(A1:A1441<=C2)*(B1:B144 1)) Mike "SRacak" wrote: Column A represents the "Date" of an occurence. Column B represents the "Cost" of each occurance. There are 1,441 rows. I want to know what the Cost is for a specific date range, the month of December 2007 (i.e. =12/01/2007 and <=12/31/2007). Any suggestion will be appreciated. ~SRacak |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create pivot table, error "Range is not valid" | Charts and Charting in Excel | |||
| sumif with "broad" sum range | Excel Worksheet Functions | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| "Create a drop-down list from a range of cells" | Excel Worksheet Functions | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
Hybrid Mode
