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

CDA_OM

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?

CDA_OM

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!

Tomasz Giba

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

CDA_OM

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

CDA_OM

Tomasz Giba

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!

CDA_OM

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!