Subtract Progammatically

[mutaforme]

Hi, I'm a newbye so please be patient.
I have two colums with several values (wattage usage in the day and wattage usage in the night).
I need a third colum which should show the daily variation between the sum of the previous day.
So, for example I have in the colum A (5,12,4) and colum B (2,3,4) and I want to display ((A2+B2)-(A1+B1) ). Then C2=8.


But I want to do that programmatically, I don't want to write A1 or B1 but I want a dynamic solution because I need to add values every day and get the report in a third column.
How can I do this?

Thak you in advance.

 

[alansidman]

In C2, type your formula that you have provided and then copy it down column C. If will automatically adjust the cells. To understand how this works, look at this link

https://www.excel-easy.com/functions/cell-references.html

 

[mutaforme]

In C2, type your formula that you have provided and then copy it down column C. If will automatically adjust the cells. To understand how this works, look at this link

https://www.excel-easy.com/functions/cell-references.html

It works and it's very easy. Thank you very much.