Absolute Values Summed for a Range

  • Thread starter Thread starter Linda D
  • Start date Start date
L

Linda D

Good Morning All,

I am wanting to sum for a range that return the absolute value for that
range. There can be multiple unknown positive or negative values in the
cells. I have done it before but I can not recall how.

Ex: (10.00)+10.00+(10.00)=30.00
 
Linda,

Use a formula like the following array formula:

=SUM(ABS(A1:A10))

Since this is an array formula, you must press Ctrl+Shift+Enter rather than
just Enter when you first enter the formula and whenever you edit it later.
If you do this properly, Excel will display the formula enclosed in curly
braces {}.
 

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

Summarize a range referenced in a separate worksheet 3
Formula required 5
Adding Columns 6
Different cells that need to sum in one 4
Sum Unique 2
Sum the "Bar Tabs" 2
assign a value to a range 7
Formulas 2

Back
Top