I cannot get a SUMIF equation to properly calculate between a date range.

My equation is the following:

=SUMIFS([June 2024]188:[June 2024]263, [Revised Budget]188:[Revised Budget]263, >="01/01/24", [Revised Budget]188:[Revised Budget]263, <="01/31/24")

The equation seems to not recognize the year in the Criteria, so all January dates it includes in the SUM without reference to the year.

These columns are setup as Text/Number, so I am unsure if that is causing an issue.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Your date columns are set as text/number type columns?

Jakep

That is correct

Paul Newcome

Is there a specific reason you are using text/number instead of date type columns for the dates?

Jakep

Strictly due to the data in the document. It was easiest to keep the columns as text/number because of other information in the sheet. I did create a separate column that is setup as a date column and I am still having the same issue, but now it won't sum any thing.

Paul Newcome

You will need a date type column with a formula in it that converts the text string into an actual date value.

=DATE(VALUE("20" + RIGHT([Text Column Name]@row, 2)), VALUE(LEFT([Text Column Name]@row, 2)), VALUE(MID([Text Column name]@row, 4, 2)))

Then you can reference this date column in your formulas being sure to use a DATE function within them.

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