sumproduct (adding sum by date)

[VegasL]

Hello,

I am comparing two columns by date and want to sum the values in next column.

I tried SUMPRODUCT(--(INT($A$2:$A$18)=E2),($F$2:$F$31)) but getting #value! error

Please see attached spreadsheet under column f, desired result.

Thanks

[VegasL]

sorry comparing column e with column a (dates) and trying to add sum of column b when dates match..

desired result is in column f

[VegasL]

ok got it figured out SUMPRODUCT(--(INT($A$2:$A$18)=E2),($B$2:B$18)