#Value! error on SumIF

I keep receiving a value error on my worksheet for several cells. I am able to fix it for myself by shortening the reference cells but the folder is a shared folder and it causes everyone else to hav...