Trying to Sum a column with a condition and date range
Hi all, I am trying to Sum a column with a condition and date range where vacancies range 1 is the column to be summed, range 2 has the condition and range 5 is the date range. I've tried the below formula and it comes up as unparseable. Can someone please assist?
=SUMIFS({2023 / 2024 Vacancies Range 1}, {2023 / 2024 Vacancies Range 2}, "Filled - SRS"), {2023 / 2024 Vacancies Range 5}, AND(@cell >= DATE(2023, 3, 1), @cell <= DATE(2023, 5, 31)))
Best Answer
Answers
-
-
Yes, I cant believe that was right in front of my eyes, thanks so much for your help!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!