Stumped on a SUMIFS for Fiscal Year (FY)
I am a bit stumped on a solution. I tend to not like to hardcode information into a formula. I was working through a solution to help manage a Business Development (BD) pipeline.
With the help of the community, I figured out how to do a YTD. But then I was thinking that it didn't make sense to have the BD operating outside of the FIN Department's FY.
I used this for the YTD calculation:
=SUMIFS([Dollars]:[Dollars], [Date]:[Date], YEAR(@cell) = YEAR(TODAY()))
How would you convert that to a Fiscal Year cal and then how would you do last FY cal, without any hardcoding or column creation or sheet lookup?
I am curious if it is possible. I keep getting stuck trying to figure out how to nest it right.
Help Article Resources
Check out the Formula Handbook template!