SUMIFS Reference Formula with two date columns and one condition. Formula is computing 0

Hi can anyone see if they can think of what might be causing this formula to compute 0 and not Summing the {Check In Log Range 1}

{Check In Log Range 1} = Dollar Volume

{Check In Log Range 2} = Employee Condition

{Check In Log Range 3} = Start Date

{Check In Log Range 4} = End Date

=SUMIFS({Check In Log Range 1}, {Check In Log Range 2}, =[Employee ID]@row, {Check In Log Range 3}, AND(@cell >= DATE(2024, 1, 1), @cell <= DATE(2024, 1, 31)), {Check In Log Range 4}, AND(@cell >= DATE(2024, 1, 1), @cell <= DATE(2024, 1, 31)))

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

You are basically saying to sum rows where the start date and end date both are within January 2024.

Brendan Ginns

yes correct, and it will be adjustable for the next condition of February, etc

Paul Newcome

Can you show some rows from the source data that you would expect to have calculated?

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.