| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum values between dates
In col C8:C200 I have start dates entered by date and time. In col J8:J200
I have end dates entered by date and time. In col N8:N200 I have values for each transcation. What I would like to do is in cell C1 enter a start date. In cell C2 enter a end date. In cell C3 have a formula that based on C1 and C2 find the dates that are equal to, or between the start and end dates and based on those match sum the values in col N |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
| How to dates column with values in next column | Excel Discussion (Misc queries) | |||
| FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS | Excel Discussion (Misc queries) | |||
| SUM values between dates | Excel Worksheet Functions | |||
| Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
Threaded Mode
