| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sum #s in a column based on dates in another column
I have a spreadsheet that has MANY values. One column provies the size of a
file, and another corresponding column provides the date the file was created (month, day, year -- and some have times). What kind of formula/macro can I create that will sum the sizes of the files that correspond to certain dates? For Example: COLUMN A COLUMN B 34 Jul 20, 2004 2009 Jul 20, 2004 3 Aug 11, 2005 20006 Feb 3, 2006 11:15 23 Feb 3, 2006 11:15 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
| How do I sum dollars in one column based on dates in another? | New Users to Excel | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Threaded Mode
