SUMIF within specified date
Im wondering if there is something wrong with my formula below or something I should tweak. The exact formula below returns values as expected (anything in the [Expected Revenue] Column in the year 2020. When I copy paste to another cell it just gives error messages (I am trying to do the same thing for 2021 but it won't let me). I had a similar problem getting the initial result but just kept playing around with it until it worked even though the end result was no change. Thoughts?
=SUMIF([Expected Install Start Date]:[Expected Install Start Date], YEAR(@cell) = 2020, [Expected Revenue]:[Expected Revenue])
Answers
-
Can you copy paste the exact formula from the sheet that is giving your error message(s) along with exactly which error message(s) you are getting?
-
The exact formula above works in one cell but not when I copy paste to another. It will return unparseable
-
What column is the formula in and which column are you pasting the formula to?
-
Both are within Sheet summary. I am trying to sum all expected revenue for 2020 and also 2021. I finally got it working but simply by retyping the same things multiple times. Wondering if im doing something weird or maybe there's a glitch?
-
It seems like there may be a bit of a bug in the sheet. You may want to reach out to support to see if maybe there is something they can refresh on the back-end to keep it from happening.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!