SumIf Date Range

Hi All! I'm trying to use the Summary in a sheet to tabulate an object count between a date range.

I'm trying to get a Sum of cells in a column "Number of Objects", if the "Date Imported" is between a range, 09/01/21- 08/31/22. The formula I'm using is returning "0". The formula is :

=SUMIF([Date Imported]:[Date Imported], AND(@cell < DATE(2021, 9, 1), @cell > DATE(2022, 8, 31)), [Number of Objects]:[Number of Objects])

Does the format of the date matter? Current format is "04/06/22 1:18 PM"

Find more posts tagged with

functionality

Sheet Summary

Accepted answers

Mike TV

@brbradle

Your formula is trying to find a cell with a date that's less than Sept 1st 2021 and greater than August 31st 2022. That's not possible. I think you just need to reverse the greater than and less than symbols in your formula so it's looking for something that's greater than Sept 1st 2021 but less than August 31st 2022.

All comments

Mike TV

@brbradle

brbradle

@mike TV Ha! Thank You! I missed that!

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.