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 backend to keep it from happening.
Help Article Resources
Categories
Check out the Formula Handbook template!