Sumproduct Datevalue with Numbers

[neodjandre]

For sanity checks, I wish to sumproduct the datevalue of a column with dates with a column of numbers in a table. But I am getting a value error.

=SUMPRODUCT(--(DATEVALUE(bank_trans[DATE]))*--(VALUE(bank_trans[PAID OUT])))

How could I do this please?

Many thanks,
Andrew

 

[steve the fish]

Are you trying to calculate the paid out for a particular date? What do you have in the DATE column?