Posted to microsoft.public.excel.worksheet.functions

SteveG[_3_] SteveG[_3_] is offline

external usenet poster

Posts: 6

Sum of a range of absolute numbers

I need to sum a row of numbers that are both positive and negative. What I
would like to do is sum them as absolute values.

Example:
A1=2, B1=-3, C1=-1, D1=5
Sum(abs(A1:D1)) should equal 11 (2+3+1+5) not 3 (2-3-1+5).

This doesn't work. Does anyone have a suggestion on how to do this.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can you make a range absolute?	Danielle	Excel Discussion (Misc queries)	3	November 28th 07 11:08 PM
name range from absolute to relative	WCO	Excel Worksheet Functions	9	December 13th 06 08:13 PM
Can I change a column of calculated numbers to absolute numbers?	Kate Bissell	Excel Discussion (Misc queries)	3	October 25th 06 06:10 PM
Sum a range of absolute values	lister_d_000169	Excel Worksheet Functions	4	June 1st 06 03:14 PM
How do I get the maximum absolute value of a range of numbers?	biscuitsmom	Excel Discussion (Misc queries)	2	January 19th 06 07:55 PM

All times are GMT +1. The time now is 04:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us