How do I get the sum of 6 columns (dollars) but only if a 7th column with yes/no dropdown equals no?


I have a sheet with 6 columns, one for each month of the second half of the year. I want the sum total of all 6 months, but only if a column labeled "Planned Budget", which has a yes/no dropdown, has a value of no in the same row.

Is this doable?

I have the sum of all six columns without the conditional "planned budget" column, of course:

=SUM(July:July, August:August, September:September, October:October, November:November, December:December)

but cannot figure out how to add the condition. Please help?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!