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!