| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a range of dates to add data in a different column?
I need to sum a range in a column based on the date in another column: A B 1 Date Hours 2 05--Dec-26 7.2 3 05--Dec-29 6.8 4 06--Jan-01 2.1 5 06--Jan-12 3.3 essentially, i want to say "if the date in A is in Dec 05, add the hours in B that correspond to Dec 05". so, in another cell, in another sheet, i would get: A B 1 Dec 05 14.0 2 Jan 06 5.4 B1 of the second sheet obviously where my formula would be. Thanks. -Carl Eubanks -- Outraged ------------------------------------------------------------------------ Outraged's Profile: http://www.excelforum.com/member.php...o&userid=31491 View this thread: http://www.excelforum.com/showthread...hreadid=511703 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a range of dates to add data in a different column? | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| convert text to number for a range of data in a column | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
