How do I substract numbers in range like this: Substract(a1..a10)

D

Dave Peterson

depends on what you mean...

Maybe:
=-sum(a1:a10)
or
maybe:
a1-sum(a2:a10)



Paulo wrote:
 
P

Paulo

For example: to add I do this
a1 1.00 +
a2 2.00 +
a3 3.00 +
a4 6.00 (total) =sum(a1:a3)
I want to do this
a1 6.00 -
a2 1.00 -
a3 1.00 -
a4 4.00 (total) =?(a1:a3)
 
R

Rowan Drummond

Try

=A1-SUM(A2:A3)

Regards
Rowan
For example: to add I do this
a1 1.00 +
a2 2.00 +
a3 3.00 +
a4 6.00 (total) =sum(a1:a3)
I want to do this
a1 6.00 -
a2 1.00 -
a3 1.00 -
a4 4.00 (total) =?(a1:a3)


:
Click to expand...
 

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

need held for auto date calculation for adding years and substract 1
Function for summing or counting cells based on a specified fill color 3
Substraction formula 4
Help needed for inexperienced MS Excel 2003 user 2
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Adding a negative number instead of substracting it 4
Search an array of sheets for an array of numbers & return count of numbers 11
Unique Value Count in 3 Columns Using Search Criteria 0

Top