SumProduct

Hello,

I am looking for an alternative to the following sumproduct formula which I am using, below. I am using office pro plus 2013

I am trying to calculate, for each day the sum of all (Current Price-Opening Price)*Quantity. For each name there is a different open and current price, the closing date needs to be in the future and the open date needs to either be the date that is being reviewed or in the past.


=SUMPRODUCT(--(Sheet1[Close Date]>'Sheet2'!Date)*--(Sheet1[Open Date]<='Sheet2'!Date)*--(Sheet1[columnA]=NameA),('Sheet3'!B2-Sheet1[Opening Price]),(Sheet1[ComunC]))+SUMPRODUCT(--(Sheet1[Close Date]>'Sheet2'!A2)*--(Sheet1[Open Date]<='Sheet2'!A2)*--(Sheet1[columnA]=NameB),('Sheet3'!Current Price-Sheet1[Opening Price]),(Sheet1[ComunC]))....

I am running into a problem as I can have 30+ Names on one sheet, and there becomes to many characters for excel. The names are located in the first row of sheet 3, each name has a corresponding price for each day. The Names relate to sheet 1 Column A.

Any help would be appreciated.

Thank you