Sum all values for one day ?
I have two columns
One columns is a date. There can be numerous occurances on one date. For ex, 9/10/07 can have several entries. For each date I have values of money expended on that date I want to sum the values for one date together. I need formula - Thank You fo your help!!! Example Date Value 9/1/07 2 9/1/07 3 9/2/07 45 9/3/07 34 9/2/07 1 Value for 9/1/07 should be 2+3 = 6 Value for 9/2/07 should be 45+34+1= 80 |
Sum all values for one day ?
Try,
=SUMPRODUCT((A1:A3=C1)*(B1:B3)) Where C1 is the date you want to sum. Mike " wrote: I have two columns One columns is a date. There can be numerous occurances on one date. For ex, 9/10/07 can have several entries. For each date I have values of money expended on that date I want to sum the values for one date together. I need formula - Thank You fo your help!!! Example Date Value 9/1/07 2 9/1/07 3 9/2/07 45 9/3/07 34 9/2/07 1 Value for 9/1/07 should be 2+3 = 6 Value for 9/2/07 should be 45+34+1= 80 |
Sum all values for one day ?
Hello
Value for 9/1/07 should be 2+3 = 6 This is VERY expensive! ;-) Try: (With dates in say A1:A5 and numbers in B1:B5) =SUMPRODUCT((A1:A5=DATEVALUE("9/1/07"))*(B1:B2)) HTH Cordially Pascal a écrit dans le message de news: ... I have two columns One columns is a date. There can be numerous occurances on one date. For ex, 9/10/07 can have several entries. For each date I have values of money expended on that date I want to sum the values for one date together. I need formula - Thank You fo your help!!! Example Date Value 9/1/07 2 9/1/07 3 9/2/07 45 9/3/07 34 9/2/07 1 Value for 9/1/07 should be 2+3 = 6 Value for 9/2/07 should be 45+34+1= 80 |
Sum all values for one day ?
|
All times are GMT +1. The time now is 01:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com