Sum not including writing

B

Be18

Along with numbers, I have to put text into several cells, mainly astericks
and some letters, but I also want to sum these cells. How do i sum the
numbers and exclude the text? Please help!!
 
D

Dave Peterson

Don't do it that way.

Put the indicator in an adjacent column.

You're life (and formulas) will be much easier.
 

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

Controlling Cells included in a sum command 3
Exclude text from sums 13
Excel does not accept text format! 0
Use TODAY() function as the criteria in a SUMIF formula 1
Merging from an Excel file with graphics 1
Modern equivalent of Autotext in Word? 0
Macro to select and delete levels of a document 2
How to make repeating drop-down lists? 2

Top