Month on month i will be updating a spreedsheet with new data, this is the first time for me to try and automate some of it.

however, when i use the following formula it works, but once dropping in new data the formula gives me #value back

please can you help, ive tried the formatting etc all is the same.

kind regards