Formula displays error when text inputed rather than number

B

bshupe12

I am trying to do a summation within an If/Then statement. The problem I am
having is that within that summation there could be values that are text
rather than numbers. I want the formula to just skip over the text and
continue adding the remaining cells. Another problem with this is that any
of the summation cells could contain text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top