sum(if( function where the argument logical_test contains arrays

Hi,
I can't use the AVERAGEIFS() function, because the Average price is the weighted average of the prices traded in that date, weighted by the volume of each trade (number of contracts, displayed in the array "Contracts_Blotter"