Formula to count values that are not struck through

I have a sheet with a conditional format set up to strike through the row when the finish date is reached.

I am creating a sheet summary where I would like to add up the days (in the duration column) for each project.

What is the formula I should be using? How do I set a conditional format as my criterion in a SUMIF formula?

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!