Try SUMF()

The below formula in D1 sum the values in ColB if the date in ColA is same
as the date mentioned in C1

ColA colB ColC ColD
7/17/2009 2 7/19/2009 =SUMIF(A:A,C1,B:B)
7/18/2009 3
7/19/2009 5
7/20/2009 1
7/21/2009 10
7/22/2009 15

If this post helps click Yes
---------------
Jacob Skaria


"sunsetsweete" wrote:

Hi!

I am trying to make a formula where I add up dollar amounts based on which
rows have a certain date.

I have a spreadsheet where I keep track of my sales for the day and I want
to add up my total sales in different categories for each day. Each
transaction is in a row and is dated. I have the workbooks split up into
type of sale instead of date so I need to find a way to have excel choose the
amounts based on the date given in another cell in the row.

Anyone know how to do this?

Thanks in advance!