SUMIF within specified date

Ian MacFayden

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])

Paul Newcome

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?

Ian MacFayden

The exact formula above works in one cell but not when I copy paste to another. It will return unparseable

Paul Newcome

What column is the formula in and which column are you pasting the formula to?

Ian MacFayden

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?

Paul Newcome

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.