I need help writing a (very!) complex formula

Copper Contributor

This was a mistaken second upload.

2 Replies

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-co... and is already solved.

 

Best,

Mourad

perhaps can be addressed by using pivot table first then using sum/sumif function after the data was filtered using slicers. see attached sample.