| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum values between two dates
I have a multi worksheet issue here. I have data on one sheet and I
want to show reports on a second sheet. I am trying to check ColumnA1:A1500 for dates that lie between 1/6/07 and 2/3/07, then sum the cells in ColumnL1:L1500. I can get it to do it if i select greater than or less than a certain day, but not both. I want to gather data for a whole month(first friday to first friday). My working formula is this... =SUMIF(SHEET1!A5:A1500,"1/5/07",SHEET1!L5:L1500) I am unable to actually select between two dates for some reason. Any help would be appreciated. Sorry if there is an easy explanation, I can't seem to put it together. TIA Ryan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Could anybody tell me how to add values based on dates. | Excel Worksheet Functions | |||
| Summing values b/t two dates | Excel Discussion (Misc queries) | |||
| seperating dates & values | Excel Discussion (Misc queries) | |||
| Sum values between dates | Excel Worksheet Functions | |||
| SUM values between dates | Excel Worksheet Functions | |||
Threaded Mode
