Hi guys - I am trying to learn about the sumproduct function and am looking for examples of sumproduct with:

if and vlookup

In addition, cases when sumproduct is not being used to multiply but add.

So if anyone has kept any files from when they have helped anyone. Or like me has an excel example folder, please could you pm me and i'll send you my e maill address.

Cheers