Excel column formula inexplicably skips a cell

Copper Contributor


As you will see in the below spreadsheet I havve a formula for column K (which is the same as column J) that does not calculate correctly.


Column J adds up fine, column K does not...

I would appreciate some help with this.

Thank you.


2 Replies


What is the result of ISNUMBER(K3)?


Hello Detief,
I pasted the data into the cell, it looked like a number, it was not.... Thank you for your help.