How to count dollar values relating to dates

[r.napier]

I have created a large spreadsheet which breaks out a monthly forecast and within this forecast there are dollar values relating to each of the items on this forecast. In the same row as these dollar values i have assigned a date to each item. I would like to produce a table as seen below which counts all of the dollar values associated with each date. The thinking behind this is so it shows me a table which summarises all the dollars associated with each date.

November	Total $ so far	Daily target
11/1/2012
11/2/2012
11/3/2012
11/4/2012
11/5/2012
11/6/2012
11/7/2012
11/8/2012
11/9/2012
11/10/2012
11/11/2012
11/12/2012
11/13/2012
11/14/2012
11/15/2012
11/16/2012
11/17/2012
11/18/2012
11/19/2012
11/20/2012
11/21/2012
11/22/2012
11/23/2012
11/24/2012
11/25/2012
11/26/2012
11/27/2012
11/28/2012
11/29/2012
11/30/2012

<COLGROUP><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><TBODY>
</TBODY>

The daily target would be the forecasted count and the 'total so far' would be the actual count in terms of the dollars made on that date.


Thanks


Please help

November	Total $ so far	Daily target
11/1/2012
11/2/2012
11/3/2012
11/4/2012
11/5/2012
11/6/2012
11/7/2012
11/8/2012
11/9/2012
11/10/2012
11/11/2012
11/12/2012
11/13/2012
11/14/2012
11/15/2012
11/16/2012
11/17/2012
11/18/2012
11/19/2012
11/20/2012
11/21/2012
11/22/2012
11/23/2012
11/24/2012
11/25/2012
11/26/2012
11/27/2012
11/28/2012
11/29/2012
11/30/2012

<COLGROUP><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><TBODY>
</TBODY>

 

[meddem]

It's really hard to tell from your description how your data is arranged. Does each cell in each row of data consist of dollar amounts, except for one cell that contains a date? Are the items associated with the dollar amounts named in a header row?

Maybe you could post a representative sample of your data.

 

[Teeroy]

If the answer to @meddem's questions are yes then SUMIF will work for you. eg =SUMIF(A4:A20,"=" & A24,B4:B20) will sum all $ from range B4:B20 where the date in A24 matches the date in range A4:A20.