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 ca...