Hello,
I am first time poster looking for help with a formula which uses a sumproduct and vlookups:
=SUMPRODUCT((VLOOKUP(__,__:__,{2,3,4,...},FALSE)>0)*VLOOKUP(__,__:__,{2,3,4,...},FALSE))
Here is a simple example of the formula in action:
https://i.imgur.com/i49xcNl.png
While the formula...