Sum If Column is not blank

Hello everybody,

Hope you are well!

I was wondering, is there a way to SUMIF when a column at a row isn't blank? For some reason, I can't come up with a formula that will sum up the volume if the countries column below is not blank.

I was able to parent them and then use the below formula, which works

=SUMIF([Column5]:[Column5], "June 26th Week", Volume:Volume)

I am just trying to see if I could use something like the below:

=SUMIF(Volume:Volume, NOT(ISBLANK([Countries - Completed Moves]:[Countries - Completed Moves])))

If it's not possible that's ok, I thought I'd ask :)

Thanks for your help!

Find more posts tagged with

Formulas

Accepted answers

Matt Johnson

Hi @Josue RQ

If I follow right, I think the formula below is what you are looking for. It sums the Volume column for only rows where the Countries column is not blank.

=SUMIF([Countries - Completed Moves]:[Countries - Completed Moves], <>"", Volume:Volume)

I hope that helps.

Matt

=Chris Palmer

Hi @Josue RQ

Something like this perhaps?

=IF(ISBLANK(Countries@row), "", SUMIF($Countries$1:$Countries$6, $Countries@row, $Volume$1:Volume$6))

All comments

Matt Johnson

Hi @Josue RQ

If I follow right, I think the formula below is what you are looking for. It sums the Volume column for only rows where the Countries column is not blank.

=SUMIF([Countries - Completed Moves]:[Countries - Completed Moves], <>"", Volume:Volume)

I hope that helps.

Matt

=Chris Palmer

Hi @Josue RQ

Something like this perhaps?

=IF(ISBLANK(Countries@row), "", SUMIF($Countries$1:$Countries$6, $Countries@row, $Volume$1:Volume$6))

Josue RQ

Thank you, Matt and Chris! Both of your solutions work :)

I thought that the NOT(BLANK was an option, so glad to see I wasn't missing something

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.