Sum a set of RANGE questions/values

JonathanPollack

I know I can use a calculation to sum a set of "Integer" values in a "calculation", e.g. (${integer1} + ${integer2}).  I can't seem to get this to work with "Range" question types.  Is there a known workaround?  I want to show the total of 10 Range questions.

jcarlson

How is your XLS Form configured? What you're attempting to do works just fine without any workarounds.

Worth noting: a calculation written like ${integer1}+${integer2}... won't return an answer until all summed fields have a valid number in them, so you won't see the sum if one of the ranges doesn't have an answer.

If that's an issue for you, just set a default value for each range question.