Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum all values for one day ?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |