Conditional Sum

[JohnJ]

I have a spreadsheet that records details of individual
transactions. The first column is the transaction date.
There be only 1 transaction per day or 50.

I want to create a routine that will sum values by day. I
have tried using conditional sum, so far without success.

Any ideas

 

[Peo Sjoblom]

One way

=SUMIF(A:A,DATE(2004,5,27),B:B)

for today, change date to fit your needs

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Jason Morin]

I'd suggest using a Pivot Table and refreshing it as
needed. MVP Jon Peltier has some material on Pivot Tables
at:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm

HTH
Jason
Atlanta, GA

 

[Guest]

Menu - Data/SubTotals - assumes you have titles and that the dates (transactions) are grouped by date. You specify what you want to subtotal on, in this case a change in the date

Date Tran
5/1/2004
5/1/2004
5/1/2004
5/1/2004 Total
5/2/2004
5/2/2004
5/2/2004
5/2/2004 Total
Grand Total 1