Limit Results to Specific Year
Best Answer
-
It worked!!!
Would you mind showing me how to do the same with a sum?
=SUM({ARC Range 3})
Answers
-
Try something like this (note the COUNTIFS with the S to allow multiple range/criteria sets)...
=COUNTIFS({ARC Range 2}, "Closed", {ARC Date Column}, IFERROR(YEAR(@cell), 0) = 2019)
-
It worked!!!
Would you mind showing me how to do the same with a sum?
=SUM({ARC Range 3})
-
Happy to help! 👍️
You would use a SUMIFS. You would have the same range/criteria immediately after the range you would want to sum, so it would look something like this.
=SUMIFS({ARC Range 3}, {ARC Range 2}, "Closed", {ARC Date Column}, IFERROR(YEAR(@cell), 0) = 2019)
Please don't forget to mark the answer that most appropriately answered your original post so that others can know a solution has been found.
-
The solutions provided for both my questions are perfect.
Thanks!!!
-
Help Article Resources
Categories
Check out the Formula Handbook template!