#VALUE!

%3CLINGO-SUB%20id%3D%22lingo-sub-2649199%22%20slang%3D%22en-US%22%3E%23VALUE!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2649199%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20tried%20to%20copy%20the%20formula%20and%20enter%20it%20into%20the%20entire%20column%20however%20the%20error%20appears.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20have%20tried%20a%20number%20of%20different%20things%20including%20changing%20the%20format%20from%20text%20to%20general%20to%20number%20and%20nothing%20seems%20to%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2649199%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2649221%22%20slang%3D%22en-US%22%3ERe%3A%20%23VALUE!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2649221%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1128677%22%20target%3D%22_blank%22%3E%40keysemm24%3C%2FA%3E%26nbsp%3BThe%20picture%20doesn't%20reveal%20much%2C%20other%20than%20that%20column%20FP%20seems%20empty%20for%20most%20of%20the%20rows.%20But%20are%20they%20really%20empty%3F%20Perhaps%20there's%20a%20single%20space%20in%20the%20cells.%3C%2FP%3E%3CP%3EIf%20so%2C%20a%20formula%20like%20%26nbsp%3B%3CEM%3E%3CSTRONG%3E%3DFK3%2BFP3%3C%2FSTRONG%3E%3C%2FEM%3E%26nbsp%3Bwill%20result%20in%20%23VALUE.%20You%20could%20try%20%3CEM%3E%3CSTRONG%3E%3DSUM(FK3%2C%20FP3)%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies

@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)

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

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