Hi Community - I have a formula that performs a simple calculation by summing a series of cells.
The challenge comes in that some of these cells contains text, rather than numbers. I would like the formula to ignore the text so that a total can be calculated.
Currently, a ‘NaN’ is being returned. I attach an image of the cells that I am trying to calculate and the simple formula is: