Struggling with using SUMIFS to sum rows within the year

Hi all- I am trying to add up the # of days in my "Actual LOS" column that are both within the year 2024 and have the "Campus 1" value under the "Referral Facility" column. I'm struggling with the the year part of the function- would appreciate any insight into how to simplify this or make this formula work. It's currently coming up as unparseable.

Thanks in advance!

=SUMIFS([Actual LOS]:[Actual LOS],[Referral Facility]:[Referral Facility],"Campus 1",[Referral Date]:[Referral Date], AND(@cell > DATE (2024, 1, 1), @cell < DATE(2024, 12, 31)))

Find more posts tagged with

Accepted answers

All comments

heyjay

Can you please try this?

=SUMIFS(
[Actual LOS]:[Actual LOS],
[Referral Facility]:[Referral Facility], "Campus 1",
[Referral Date]:[Referral Date], >DATE(2024, 1, 1),
[Referral Date]:[Referral Date], <DATE(2024, 12, 31))

If you want to incorporate the AND function…

=SUMIFS(
[Actual LOS]:[Actual LOS],
[Referral Facility]:[Referral Facility], "Campus 1",
[Referral Date]:[Referral Date],
  AND(@cell >DATE(2024, 1, 1),
      @cell <DATE(2024, 12, 31)

syolleck

the second formula worked. thank you so much!

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.