Hi Vince28,

First of all, today's sales are not 70 but 80. Second, use SUMIF
instead.

6/1/2005        50
6/1/2005        50
6/3/2005        60
6/3/2005        20

CRITERIA        SUMIF

In CRITERIA cell (A6), type: 6/3/2005 (or any other date)
For SUMIF cell (B6) type: =sumif(a1:a4,a6,b1:b4)

Cheers.