#VALUE! error adding cells
 

I am trying to add a row of numbers contained in every other cell. This
worked fine and I was able to copy the formula from one cell to the other.
On the final cell, instead of adding the numbers, I am getting the message
#VALUE!. I cannot figure out how to correct this problem.

Check to see if you have a text value in one of the referenced cells - either
actual text or a number that looks like text


"Frustrated computer user" wrote:

I am trying to add a row of numbers contained in every other cell. This
worked fine and I was able to copy the formula from one cell to the other.
On the final cell, instead of adding the numbers, I am getting the message
#VALUE!. I cannot figure out how to correct this problem.