Not sure about the weighted average, but look at:

=SUMPRODUCT(--(A2:A9=20070904),(B2:B9),(C2:C9))/COUNTIF(A2:A9,20070904)

if 146 is o.k.
--
Gary''s Student - gsnu200747


"carl" wrote:

My data table looks like this:

Date Price Volume
20070904 17.3 10
20070904 17.3 10
20070904 23.8 5
20070904 23.8 5
20070905 5.7 10
20070905 5.7 10
20070905 1.55 11
20070905 1.55 11

I am looking for a formula for this table

Date WeightedPrice
20070904
20070905

So for each day, calculate the volume weighted average price.

Thank you in advance.