How can I add numbers but ignore the minus signs?

's Computer Specifications

How can I add numbers but ignore the minus signs? In the following, the
answer I'm after is 17

A1 -10
A2 5
A3 -2

's Computer Specifications

=SUMPRODUCT(ABS(A1:A3))

Gord Dibben MS Excel MVP

On Thu, 07 Jun 2007 04:19:52 GMT, Invalid <(E-Mail Removed)> wrote:

>How can I add numbers but ignore the minus signs? In the following, the
>answer I'm after is 17
>
>A1 -10
>A2 5
>A3 -2
>
>

's Computer Specifications

Gord Dibben <gorddibbATshawDOTca> wrote in
news:(E-Mail Removed):

Thank you Gord.

-----

> =SUMPRODUCT(ABS(A1:A3))
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 07 Jun 2007 04:19:52 GMT, Invalid <(E-Mail Removed)>
> wrote:
>
>>How can I add numbers but ignore the minus signs? In the following,
>>the answer I'm after is 17
>>
>>A1 -10
>>A2 5
>>A3 -2
>>
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Plus and Minus signs	Ron W.	Windows Vista Mail	2	10th Apr 2009 03:47 AM
Plus and minus signs in outline view	=?Utf-8?B?U3RldmU=?=	Microsoft Word Document Management	5	22nd Apr 2007 07:45 PM
Minus signs after number	Crowbar via OfficeKB.com	Microsoft Excel Programming	1	6th Feb 2006 03:14 PM
MINUS SIGNS REMOVAL	=?Utf-8?B?UmViZWNjYQ==?=	Microsoft Excel New Users	2	24th Nov 2005 12:07 AM
minus signs	=?Utf-8?B?VEZEREpD?=	Windows XP Accessibility	0	22nd Apr 2005 05:59 PM