Prev: 90 day Running total
Next: Multilayered Spreadsheet Function
From: T. Valko on 20 Jan 2010 14:15
Use the SUM function.

=SUM(A1:A3)

Instead of doing this:

=A1+A2+A3

The SUM function will ignore any cells that contain text.

--
Biff
Microsoft Excel MVP


<James McErlain> wrote in message news:20101201413james(a)kingdom.ie...
> 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/tutorials/aspnet/6bcfb018-d277-40e2-b227-17e5f15f4c9a/bing-search-rss-with-silv.aspx


From: Gord Dibben on 20 Jan 2010 14:48
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

On Wed, 20 Jan 2010 11:01:04 -0800, James McErlain wrote:

>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/tutorials/aspnet/6bcfb018-d277-40e2-b227-17e5f15f4c9a/bing-search-rss-with-silv.aspx

 | 
Pages: 1
Prev: 90 day Running total
Next: Multilayered Spreadsheet Function