Forum Discussion
Solved
Combine Sumproduct sumif or xlookup
Hi all, I am struggling with the following.... I have column H (called "Nature"), Column J (called "Weight") Column M ("Jan-22") Column "Nature" contains 3 possible values such as "Rally", "...
if I understood everything correctly, the SUMPRODUCT function should be sufficient:
=SUMPRODUCT($J$2:$J$10;$M$2:$M$10;--($H$2:$H$10=L14))
Depending on your regional settings, you might need to replace the ; with ,
if I understood everything correctly, the SUMPRODUCT function should be sufficient:
=SUMPRODUCT($J$2:$J$10;$M$2:$M$10;--($H$2:$H$10=L14))
Depending on your regional settings, you might need to replace the ; with ,
Hi,
Thank you, that is indeed what I am looking for. 🙂
Many thanks !
Wim
Thank you, that is indeed what I am looking for. 🙂
Many thanks !
Wim