Add number only in a roll contain number & $ in
 

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire