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
Check out the Formula Handbook template!