Usually I would just calculate the difference of each row like this:
Then I would sum up the values of the column like this
=SUM(C1:C10) and get my desired value.
I don't want the C-column. Is it possible to calculate it immediately?
For example I tried:
=SUM((B1-A1):(B10-A10)) (which doesn't work)
Usually I can find the answers somewhere in the documentation, but my Math-English vocabulary is a little bit rusty and with German documentation I haven't found what I was looking for.
I know I could put 10 values manually inside the sum. But this doesn't scale gracefully, I want to be able to change only a few values in the formula instead of adding 1000.