Hi all, I have two columns as follows
A B
40 0.5
35 0.2
60 1.25
70 2.00
And would like to Sumproduct the two but constraining the maximum value in column B to 1. Having a separate column that picks up the Min(B,1) is not practical as in practice I have a large number of B type columns.
My first attempt at a solution was
=+SUMPRODUCT($E9:$E1390,(MIN(D9:D1390,1)))
but it returns an error.
Many thanks for your help/suggestions!!
A B
40 0.5
35 0.2
60 1.25
70 2.00
And would like to Sumproduct the two but constraining the maximum value in column B to 1. Having a separate column that picks up the Min(B,1) is not practical as in practice I have a large number of B type columns.
My first attempt at a solution was
=+SUMPRODUCT($E9:$E1390,(MIN(D9:D1390,1)))
but it returns an error.
Many thanks for your help/suggestions!!