ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sum multiple rows based on progressing date field on each row (https://www.excelbanter.com/excel-worksheet-functions/69115-sum-multiple-rows-based-progressing-date-field-each-row.html)

Thane

sum multiple rows based on progressing date field on each row
 
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



All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com