SUMIFS Formula with multiple criteria excluding blanks

I would like to sum a column, only if another column with dates falls between certain dates, and if another column with dates is not blank. I have the first part of the formula sorted but can't get the part to include if another column is not blank. The formula I have is:

=SUMIFS({Area (m2)}, {Del Date}, >=[Start Date]@row, {Del Date}, <=[End Date]@row)

The formula needs to include if the payment date is not blank.

Hope this makes sense?

Find more posts tagged with

Formulas

Accepted answers

KPH

Hi @B Young

You can add another range and criteria

{Payment date reference}, <>""

Where Payment date reference is whatever you name your cross sheet reference to the payment date column.

=SUMIFS({Area (m2)}, {Del Date}, >=[Start Date]@row, {Del Date}, <=[End Date]@row,{Payment date reference}, <>"")

B Young

Thank you! This has solved the question - appreciate your prompt response.

All comments

KPH

Hi @B Young

You can add another range and criteria

{Payment date reference}, <>""

Where Payment date reference is whatever you name your cross sheet reference to the payment date column.

=SUMIFS({Area (m2)}, {Del Date}, >=[Start Date]@row, {Del Date}, <=[End Date]@row,{Payment date reference}, <>"")

B Young

Thank you! This has solved the question - appreciate your prompt response.

KPH

Glad I could help.

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.