=sumproduct((a2:a222=a1)*(a2:a222<b1)*b2:b222)

--
Don Guillett
SalesAid Software

"Val" wrote in message
...
I am working on a spreadsheet that I would like to total each day.
I have Column A (Manually entering in a date), Column B is where a valued
is
entered. An. Example would be
A1 03/01/07- B1 5, A2 03/01/07- B2 10 and A3
03/05/07 and B3 4
A date in Col A. could range from a row or several hundred rows (
tracking
packages shipped). Column B is the value of each package. I am looking
for
a way to track everything on a per day basis. Any Suggestions??