Excel - Ignoring the contents of cells when there are letters in thecell

J

James McErlain

When using MS Works I can enter letters and numbers in a cell and the total of the cells in a row will be calculated correctly(for my particular requirement) by ignoring anyone of the cells in the row which has letters and numbers together. All the cells are formated as 'General'.

When I try to do this task in Excel it gives an error in the result cell.
Note that any cell may have a mixture of letters and cells.
Any help would be appreciated.

Thank you
James


Submitted via EggHeadCafe - Software Developer Portal of Choice
Bing Search RSS with Silverlight 3 RIA Domain Service
http://www.eggheadcafe.com/tutorial...7-17e5f15f4c9a/bing-search-rss-with-silv.aspx
 
T

T. Valko

Use the SUM function.

=SUM(A1:A3)

Instead of doing this:

=A1+A2+A3

The SUM function will ignore any cells that contain text.
 
G

Gary''s Student

If A1 thru A3 contain:

1
junk
3

then =A1+A2+A3 will show an error
however =SUM(A1:A3) will show 4
This is because the SUM() function ignores text.
 
G

Gord Dibben

SUM function ignores text cells.

ab123 is text

123 is a number

=SUM(A1:A10) will sum cells with numbers only.


Gord Dibben MS Excel MVP
 

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

Multiple Variables in Conditional Formatting with Excel 2003 1
Build a sheet name in an Excel formula 2
Excel 3
the sum of cells with letters in them 4
Duplicate the contents of a row when text is entered in a cell 10
Who can help the NYPD with an Excel formula? 20
The Search Key was not found in any record... 0

Top