SUMIFS when a column is not blank

I have multiple sheets that I am working from where I need to sumifs a column only if another column in the same row is not blank.

This is what I want to do:

If {Column C} is Blank or more than 0, Sumifs {Column B}, if {Column A} is checked

This is what I've tried:

=IF(SUMIFS({Column C}) < 0, "", SUMIFS({Column B}, {Column A}, 1))

Please help

Find more posts tagged with

Accepted answers

Vince_S

Check your formula - you have it set to Column C<0 instead of >.

If I understand correctly it should work with a Sumifs statement:

=SUMIFS(ColumnB:ColumnB, [Column A]:[Column A], 1, [Column C]:[Column C],>0)

You are summing the vaules in Column B if the row in Column A=1 (or checked) and column C is

Vince

All comments

Vince_S

Check your formula - you have it set to Column C<0 instead of >.

If I understand correctly it should work with a Sumifs statement:

=SUMIFS(ColumnB:ColumnB, [Column A]:[Column A], 1, [Column C]:[Column C],>0)

You are summing the vaules in Column B if the row in Column A=1 (or checked) and column C is

Vince

@Diana

Thank you! The formula was easier than I was thinking it was going to be.

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, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.