Hello every one!
Can you, please, help me with an advice on how to improve my formula, so that the second part of the formula with SUM function would include only numbers, which are above non-zero numbers? Just to give a background: this is a kind of returns calculations with weights. The range by which I divide the sumproduct is the weight.
Just to clarify, maybe I need a kind of criteria for SUM function which states SUM only if the cells below SUM range are non-zero.
To be more clear, I attach a sample file.
Thank you beforehand!
Bookmarks