SUMPRODUCTIF Equivalent

If I have 31 rows, one for each day of the month, how would I SUMPRODUCT all days so far this month?

I used this formula to simply SUM month-to-date values:
=SUMIF($C$5:$C$39,"<=" & TODAY()-1,D5:D39)

What would be the correlating formula for SUMPRODUCT if columns D and E are the columns to be multiplied?

1/1/2013 $12 2.10
1/2/2013 $15 1.00
1/3/2013 $16 2.00
1/4/2013 $18 1.20
1/5/2013 $14 2.50
1/6/2013 $19 2.90
1/7/2013 $20 2.10
1/8/2013 $23 3.20
1/9/2013 $22 3.10
1/10/2013 $24 2.20
1/11/2013 $25 2.20
1/12/2013 $25 2.20
1/13/2013 $25 2.20
1/14/2013 $25 2.20
1/15/2013 $25 2.20
1/16/2013 $25 2.20
1/17/2013 $25 2.20
1/18/2013 $25 2.20
1/19/2013 $25 2.20
1/20/2013 $25 2.20
1/21/2013 $25 2.20
1/22/2013 $25 2.20
1/23/2013 $25 2.20
1/24/2013 $25 2.20
1/25/2013 $25 2.20
1/26/2013 $25 2.20
1/27/2013 $25 2.20
1/28/2013 $25 2.20
1/29/2013 $25 2.20
1/30/2013 $25 2.20
1/31/2013 $25 2.20

So the value of the SUMIF formula is 137 (=SUMIF($A$1:$A$31,"<=" & TODAY()-1,B1:B31))

The value of the next formula should be 2.19, but I need that value to update automatically as we move through the month. The static formula would be =SUMPRODUCT(B1:B8,C1:C8)/SUM(B1:B8) as of today, but what formula would update the value tomorrow, and the next day, and the day after that etc automatically as the SUMIF formula above does?

From Kevin UK's formula I figured it out without having to use a pivot table:
=(SUMPRODUCT(--($A$1:$A$31<=TODAY()-1),B1:B31,C1:C31))/B32

Thanks everyone