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?
Help Article Resources
Check out the Formula Handbook template!