#Value! error on SumIF

Occasional Visitor

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 have an error. 

Initially i thought it was the drive mapping but i realized it maybe because all my colleagues are using older versions of Excel (I am using 365).

I was able to view it using the file the file-browse method but when i saved it everyone else started seeing the #value error 

How do i fix this?

1 Reply

Hi @Nii_lante 


Please could you share some more detail about the formulae that are in these cells with the #VALUE! errors?