SkiliedSin
Board Regular
- Joined
- May 7, 2018
- Messages
- 51
- Office Version
- 365
Hello,
I am currently using this function below but it is only pulling the first lookup value rather than summing all of values that fall within the index match.
=SUMPRODUCT(INDEX('Spend'!$T$2:$AE$21,MATCH($A3,'Spend'!$D$2:$D$21,0),MATCH(Model!B$1,'Spend'!$T$1:$AE$1,0)))
Please let me know if I can provide any additional information!
I am currently using this function below but it is only pulling the first lookup value rather than summing all of values that fall within the index match.
=SUMPRODUCT(INDEX('Spend'!$T$2:$AE$21,MATCH($A3,'Spend'!$D$2:$D$21,0),MATCH(Model!B$1,'Spend'!$T$1:$AE$1,0)))
Please let me know if I can provide any additional information!