I have a workbook with two tabs. A list of questions and a calculation table. In the sample, I've only included one of 10 different sections in order to keep it simple..... I can add to the other sections with the formula provided. I want to have a formula in the calculation table that looks at the cell value in the questions tab ("True", "False", "Partial") and looks at the stage (1, 2, 3, 4 or 5) and based on the fact that the question falls within 1-5, have it calculate (additive) the value of all answers (True, False, Partial) / by the number of occurances (as to fomulate "an average"), placed in the correct column (1 - 5). The value of True, False and Partial may be able to be changed on the Calculation Tab and presently has the value True = 2, Partial = 1 and False = 0. What I'm trying to avoid is building out an entire table of answers; I think there is an elegant formula for calculating it with "if statements".
Thank you in advance.
Bright01
Questionaire-v1.xls