You gave us no information about how your worksheet is set up. So, assuming
your Date/Amount data is on a sheet named Sheet1 and that the data starts in
Row 2 with Column A containing the Dates and Column B containing the
Amounts, put this formula on your other sheet...

=SUMPRODUCT((Sheet1!A2:A1000=C2)*Sheet1!B2:B1000)

Note that I further assumed the date you wanted the summation for was in C2
on the same sheet where you are putting the above formula. If you have more
than a 1000 rows of data, change both 1000s to a row number that is equal to
or larger than the maximum row you ever expect to have data in. If 1000 is
too much, use a smaller number.

--
Rick (MVP - Excel)


"LuvJ1s" wrote in message
...
I am attempting to add a formula in a separate spreadsheet that counts the
value in existing cells if the row begins with a certain date. For
example,
I would like the spreadsheet to return the 'Amount' received on 12/31/2008
(15.00) and disregard all other dates.

Date Amount
12/31/2008 5.00
12/31/2008 10.00
1/1/2009 2.00
1/1/2009 4.00
1/2/2009 1.00