Thats is because I assumed ther was only one row.
Just remove the $ signs from the formula and then change the range(where you have to keep the $ signs of course) You do not have to create a CF row by row !

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post