Sum using date comparison assistance

[Spewage]

I need to sum a forecast value based on whether the "close date" is earlier than the "last order date", but cannot seem to get this to work.

I've tried using =SUMIF(I:I,(DATEVALUE(I))<DATEVALUE(H),G:G) but I get a zero result even when there is a value in the G column. H is the "close date" and I is the "last order date". H & I are formatted as dates in the international style.

I'd appreciate any help that you can give.

Thanks in advance

 

[AlphaFrog]

Excel Workbook
	A	B	C	D
1	Close Date	$$$	Last Order Date	total
2	5/18/2011	$ 1.00	5/22/2011	$ 10.00
3	5/19/2011	$ 2.00
4	5/20/2011	$ 3.00
5	5/21/2011	$ 4.00
6	5/22/2011	$ 5.00
7	5/23/2011	$ 6.00
8	5/24/2011	$ 7.00
9	5/25/2011	$ 8.00
10	5/26/2011	$ 9.00
Sheet

 

[Spewage]

AlphaFrog,

Thanks very much for that speedy assistance!

Now I just need to massage the actual figures to look good