reference a cell using IF inside VLOOKUP on google sheets

I want to perform a vlookup with an if statement inside. i currently have

=LOOKUP("Metallic Gold Flash Tattoo Arabic",A:A,IF(INDIRECT(ADDRESS(ROW(), E)))<0,INDIRECT(ADDRESS(ROW(), C)),0)

I want to sum up all the units of that product type in column A, however i only want to sum up the ones that have been sold and not bought. column C is units and E is price. sold are positive and negative are bought.

I am using google sheets