Hello I need help with creating a formula.

Options

So basically I need to calculate the sum of scores but the total depends on 29 (from the image below) so if 29 is W, the sum is added excluding 28 and if 29 is C then we exclude 27.

Does anyone know if I can possibly have excel detect the change of row 29 and based on it, it exclude and calculate the right range?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!