Greetings,
I have a survey sheet that includes a series of pulldata functions that return a numeric value to a specific response. I would like to sum/total those individual numerics to calculate a total score. Examples below:
XLS sheet-
Survey form-
I have scoured some of the other questions/responses on the forum and tried some 'if' statements but not having much luck (it may only be a formatting issue)
Thanks,
MC