Sumifs with references and dates not calculating

HELP!!!! I am working in a summary metrics sheet. I am trying to find the total projected revenue by month. I have created 2 references, the revenue column to sum, and the date column. For some reason I keep getting 0 even though there is revenue in the column for that date. I can't figure out what is wrong with my formula.

=SUMIFS({Implementation List with Form Range 7}, {Front Office Team Range 1}, <=DATE(2023, 1, 1), {Front Office Team Range 1}, >=DATE(2023, 1, 31))

This is trying to find the projected revenue for January

Find more posts tagged with

Accepted answers

Carson Penticuff

As written, you will not get any matches. Your formula is looking for a date that is both less than or equal to January First and Greater than or equal to January 31st. You will need to reverse those to match January numbers.

All comments

Carson Penticuff

VTwyford

Oh my goodness! Thank you so much for catching that!!

Carson Penticuff

Far too often, its the little things...

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.