Function for + and - numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I ran a query that dumps into Excel, but their format shows + and/or - with
the number in the cell. I want to add the cell content, but ignore the + or
-................can I do this and if yes............what formula do I use?
 
Hi,

instead of =SUM(A1:A10)

use =SUM(ABS(A1:A10))

Enter this last formula by pressing Shift Ctrl Enter instead of Enter. Or

=SUMPRODUCT(ABS(A1:A10)) this doesn't need Shift Ctrl Enter

Cheers,
Shane Devenshire
 
You must log in or register to reply here.

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

Set add function ignore #N/A 1
Adding recognised Zeros 5
Function help required... Between funtion 2
Excel How to add numbers in same cell? 2
#DIV error 2
Subtraction Function using cells with other functions in them 2
how do I get a function formula cell to format as a number? 5
excel sum function 2

Back
Top