| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What should formula look like to define date range on SUMIF
Basically, I want to select a date range of records and apply the SUMIF
formula to the selected records. What should that formula look like? For example, for pants sold before 10/22/2009 and after 10/2/2009? A B C 1 Date Description Amount 2 10/1/2009 pants 100 3 10/15/2009pants 100 4 10/16/2009pants 200 5 10/22/2009pants 300 6 10/23/2009pants 400 7 9/22/2009 pants 500 8 11/2/2009 pants 600 9 9/3/2009 pants 700 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to define non-contiguous range? | Excel Discussion (Misc queries) | |||
| Sumif date range | Excel Discussion (Misc queries) | |||
| Use a formula to define a range | Excel Discussion (Misc queries) | |||
| How to define range of values in a formula? | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
Threaded Mode
