Excluding Text combined with numerical value in EXCEL 2003

  • Thread starter Thread starter MW
  • Start date Start date
M

MW

I have a column of numbers of which some have an * in front. When doing
AutoSum it excludes these values which I want to keep. How do I create a
formula to recognize the values but exclude the text. Thanks
MW
 

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

Similar Threads

Count total values excluding some data 6
autosum 3
Min Excluding Value 8
NETWORKDAYS and excluding vacation/PTO time used 2
Formula percent complete excluding given text string 2
averaging separate cells in excel excluding 0 values 2
Sum a Filtered List excluding Negative Numbers 6
Exclude text from sums 13

Back
Top