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?

Find more posts tagged with

Formulas

Accepted answers

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!

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.