I need help writing a (very!) complex formula

Hi,

sounds like that it could be a case for multiple conditions with SUMPRODUCT. Please see this article for a tutorial: https://www.ablebits.com/office-addins-blog/2016/08/24/excel-sumproduct-function-formula-examples/

Additional note: I have just seen, that this question is a duplicate one of this one https://techcommunity.microsoft.com/t5/Formulas-and-Functions/Need-help-with-very-complex-formula-conditional-if-find-lookup/m-p/88200#M1112 and is already solved.

Best,

Mourad