Hello I need help with creating a formula.

Alyaa

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?

Paul Newcome

Are you working in Excel or in Smartsheet. If Excel, you may want to find a forum that is dedicated to Excel as this is a Smartsheet specific help forum.

You can give this forum a try:

https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral