Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have spent several days digging in the help documentation but I am just not
getting it..... I have a sheet that contains 30 days of data from a select statement import, after tailoring with macros I end up with: Data varies between 6 - 8 rows of data per day date. I want to sum one column(C) per row of data per date(A) into a daily total in Column D in an automated routine. Any suggestions?. A B C D 1/2/06 COLOC_TAPEPOOL 415,865,778,739 1/2/06 ENT_TAPEPOOL 225,837,650,638 sum total for day here 1/3/06 (DIFFERENTIAL) 26,006,331,392 1/3/06 GENTAPEPOOL 89,365,376,624 1/3/06 (DIFFERENTIAL) 213,924,297,728 1/3/06 (DIFFERENTIAL) 380,020,412,416 sum total for day here 1/4/06 ENT_ARCH_TAPEPOOL 0 1/4/06 COLOC_TAPEPOOL 351,722,484,436 sum total for day here Thanks - Thane |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Move multiple rows of data that are not sequential | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Show a date based on today | Excel Worksheet Functions |