Sumproduct for two different categories

[hermione_on_ice]

Hi everyone,

I have a number of transactions in Excel listed in columns A-C (security, quantity and date). Based on specific dates and security names in columns G and H, I was trying to figure out a way to sum up all the transaction for a given name that happened up to (and including) that date. I am using this formula, but the results I got seem to wrong.

SUMPRODUCT(--(A$1:A$100=H$5),--(C$1:C$100>=G$5),--(B$1:B$100))

If anyone could please take a look and let me know where things went wrong, it would be a huge help.