The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
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...