I have a range of lengths. I need to sum them after pushing them through a function. Unfortunately the sum operator is not happy and stating: "Ranges with units must specify the second value in the range". Thank you for your time and help.
First off: Yes the worksheet is needed! (You should ALWAYS attach the worksheet, or a minimised version, that shows your problem).
Assuming you have i defined as a range with units, this is Prime behaviour:
Success!
Luc
I don't think that the OP has defined a range variable above the expression shown in the pic. It looks to me that the problem is rather that the upper limit of his sum is not a simple scalar but a quantity with a unit, maybe a length. So basically he is trying to do something like
Unfortunately I wasn't able to get the desired result using the sum operator alone without having to define something else like a vector or a a global range variable on worksheet level 😞
OK, one way to avoid defining anything else is to get rid of the units in the summation and add them to the function argument, but I would not recommend doing so:
