#VALUE!

[keysemm24]

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

[#2 · Accepted 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)

[#3]

Yes the first 253 cells are empty in FP column. There are two conditional groups - hence the empty cells. /Users/emmakyeys/Desktop/Screen Shot 2021-08-15 at 2.47.44 pm.png

[#4]

thank u!! it worked :) novice excel user and have been struggling with this for a while.