Excel column formula inexplicably skips a cell

New Contributor

Greetings,

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.

Jean-Pierre

2 Replies

@dareys 

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.
Jean-Pierre