| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing a range if it meets criteria between 2 dates.
I need to sum a range(columns H1:K6) that meets certain criteria (between to
dates)EX:2007-10-01 thru 2007-10-31.Dates are unknown and not consistant. My table starts fresh with each fiscal year(october 1). EX: A B C D E F G H I J K 1 07/10/01 100.00 50.00 2 07/10/25 25.00 200.00 3 07/10/31 100.00 5.00 25.00 4 07/11/07 500.00 30.00 5 07/11/30 6 07/12/23 100.00 10.00 20.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a range of cells based on criteria in another range | Excel Worksheet Functions | |||
| Populate worksheet with data that meets date range criteria | Excel Worksheet Functions | |||
| RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
| Need to identify a column within a range that meets criteria | Excel Programming | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
![Hammer[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
