| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum range of values that meet date criteria
I have a database on Sheet1. Column A contains dates, the database is sorted
ascending. Column B contains my values. On Sheet2 I want to sum information from the database in weekly increments. On Sheet2 I've entered the start date for the week in Column A, and the end date for the week in Column B. What formula could I use in Column C (Sheet2) to sum a week's data from Column B (Sheet1)? I've searched google groups, and tried a few things, but struck out. Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summary of values from a date range | Excel Worksheet Functions | |||
| Counting Values that meet another cells criteria | Excel Worksheet Functions | |||
| Sum the values of one column, only if they meet certain criteria . | Excel Worksheet Functions | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
| Counting values within a Date Range | Excel Discussion (Misc queries) | |||
Threaded Mode
