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

It wasn't what I was looking for initially, but I used it to create a new column, and then totaled that column to get the number I needed. Thank you!
Answers

=IF([Planned Budget]@row="no",SUM(July:July, August:August, September:September, October:October, November:November, December:December))
Tomasz Giba

Unfortunately, that comes back either as "#Unparseable" or a blank cell, though the formula stays.

Below formula will sum values only at one row at a time:
=IF([Planned Budget]@row="no",SUM(July@row:December@row))
is this is what you are looking for?
If not, please share some screen shots. Thanks!
Tomasz Giba

It wasn't what I was looking for initially, but I used it to create a new column, and then totaled that column to get the number I needed. Thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!