| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula date range
I have dates in column A, codes in column B and amounts in column C on
spreadsheet 2 (data). I want on sheet 1 to say that if the date falls in a certain range (ex. July 1-July 31,2009) and the code is a specific code (ex. AT) then sum the amounts in column C. This is the formula I was using but it's not working. I can't figure out the date range piece of the formula. =SUMPRODUCT(--(data!$B$2:$B$503="HP"),--(data!$A$2:$A$503="09/01/2009-09/30/2009"),data!$C$2:$C$503) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a formula to determine if date falls within a date range then | Excel Worksheet Functions | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| IF Date range formula | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Threaded Mode
