ExcelBanter - View Single Post

Ron Rosenfeld

On Thu, 11 Oct 2007 04:04:36 -0700, 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

SUMIF is a function that will work.

If, for example, you have the dates in the month in E1:En, you could use the
formula:

=SUMIF(Date,E1,Value)

Where Date and Value are the named ranges of your columns in your data table.

Or, using cell references and formulas:

=SUMIF(A:A,DATE(2007,9,1),B:B)

Note that I have entered the date in an unambiguous fashion using the DATE
worksheet function.

By the way, 2+3 = 5 and not 6.

And your values for 9/2/07 are only 45 + 1. The 34 would be included in 9/3/07
--ron