Sum all values for one day ?

[mschmidt]

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

 

[Guest]

Try,

=SUMPRODUCT((A1:A3=C1)*(B1:B3))

Where C1 is the date you want to sum.

Mike

 

[papou]

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

 

[Ron Rosenfeld]

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