Struggling with using SUMIFS to sum rows within the year

syolleck

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)))

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!