Aug 14 2021 09:27 PM - edited Aug 14 2021 09:34 PM
I have tried to copy the formula and enter it into the entire column however the error appears.
I have tried a number of different things including changing the format from text to general to number and nothing seems to help.
Thanks
Aug 14 2021 09:42 PM
Solution@keysemm24 The picture doesn't reveal much, other than that column FP seems empty for most of the rows. But are they really empty? Perhaps there's a single space in the cells.
If so, a formula like =FK3+FP3 will result in #VALUE. You could try =SUM(FK3, FP3)
Aug 14 2021 09:48 PM
Aug 14 2021 09:51 PM
Aug 14 2021 09:42 PM
Solution@keysemm24 The picture doesn't reveal much, other than that column FP seems empty for most of the rows. But are they really empty? Perhaps there's a single space in the cells.
If so, a formula like =FK3+FP3 will result in #VALUE. You could try =SUM(FK3, FP3)