How to use Excel subtraction in a set of numbers?

0

I want to subtract all the values from this small table, but if I have 100 different values, I would have some formula to summarize all the values in the same way as the formula sum, EX: = SUM (B3: B8), without specifying cell by cell? For example, in Excel, there is no formula "= SUB ()", in the case I also wanted it to have the division "= DIV", how do I proceed with this problem ??

    
asked by anonymous 18.11.2018 / 00:37

1 answer

1

Your question is a bit confusing, will subtract what from what? If you are doing something equivalent to the Sum function at the end you would have a negative value: -360. If this is the goal you can do: = SUM (B3: B8) * -1

If you want to replace the entire value of a value that is in cell C1 for example you can do: = C1 - SUM (B3: B8).

To divide you can use the Bar: '/', example: = 4/2

    
18.11.2018 / 02:26