So lets say I have 2 columns, A e B, like for example:
A B C
-----------------------------
1 | | A | B |
-----------------------------
2 | | 4 | 19 |
-----------------------------
3 | | 4 | 26 |
-----------------------------
| .... and so on .... |
-----------------------------
# | Total | 37 |
-----------------------------
So basically I want to subtract every cell (A-B) and add every columns.
The math expression would be (C2-B2)+(C3-B3)+...+(n#-(n-1)#) Can anyone explain how it is done? Thanks in advance
--- Update ---
So now I have to input letters in middle and that row won't count, like:
A B C
----------------------------
1 | | A | B |
----------------------------
2 | | 4 | 19 |
----------------------------
3 | | 4 | 26 |
----------------------------
4 | | N.A. |
----------------------------
5 | | 5 | 21 |
----------------------------
6 | .... and so on .... |
----------------------------
# | Total | 53 |
----------------------------
So now the row number 4 wont count but all other will.