| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Ability to sum data by varying dates
I have numerous lists of data going back several years organized simply col1
- date col2-data. Frequently I need to go back and provide sum totals (sometimes avg etc) over a requested date range. Is there a way to utilize a lookup function of some sort whereby I can enter a start and end date and have excel sum the range based on the dates? Now I manually check the lists to figure out the range that needs to be included in the calculation. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| extracting data from a text string of varying length | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
Threaded Mode
