Add number only in a roll contain number & $ in

S

Shane Devenshire

Hi,

1. Please enter a quesion in the body of your emai; if you don't the web
won't let us reply, instead it displays the following error message.

"An error occurred while sending your post

We're sorry, but there was a problem with the system and your post was not
received. The error has been reported to Operations and will be investigated
as soon as possible. Please try again later."

2. What exactly is your question? What formula are you using, what does you
data look like, and what answer do you want?

=SUM(A1:A100) only adds numbers, it ignores 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