Hi guys. I ave been fighting with this for a while and will be really appreciated your help.
I need to get the sum amount IF
1. Store number matches X
2. Period matches Y
3. Account matches a range I2:I4

I cannot figure out how to use this range I2:I4 as a criteria for SUMIFS.
From another side I found out how to use 3rd criteria =SUMPRODUCT(SUMIF(C:C,I2:I4,E:E)). But I don't know how I can extract an array from this formula to merge with other conditions.

Please see the example in the attachment.forum example.xlsx