the sum subtract each cell with a specific cell

[Fayezsamea]

hi 

I want to get the total of subtracting each cell from 18 Sep till 24 Sep with the daily WH 

ex. =(12.16 -11)+(12.17-11)+(16-11) and so on

Daily WH		18-Sep-20	19-Sep-20	20-Sep-20	21-Sep-20	22-Sep-20	23-Sep-20	24-Sep-20
11		12.16	12.17	16	15.45	16.49	17.01	16.55

[#2]

@Fayezsamea 

Like this?

[#3]

@Fayezsamea 

Something like this

drag it to the right

[#4]

can I add an if condition to calculate only if the value is above  Daily WH

and another one for if the value is less than  Daily WH

[#5]

@Ramiz_Assaf 

thank you for your answer it helped me a lot

same formula I want to calculate on if the number is greater than 11, and another formula only if the number is less than 9

Daily WH		18-Sep-20	19-Sep-20	20-Sep-20	21-Sep-20	22-Sep-20	23-Sep-20	24-Sep-20
11		12.16	12.17	10.1	15.45	16.49	9	16.55

like the extra Hrs are (12.16-11)+(12.17-11)+(15.45-11) and so on

and for the less Hrs ONLY (11-10.1)+(11-9) and so on

[#6]

@Fayezsamea 

As variant

[#7]

@Sergei Baklan 

amazing, what if want the total of all cell in one formula

[#8]

@Fayezsamea 

Here it is done in once cell

similar to the logic I used before

[#9]

@Fayezsamea 

Just for the collection one more variant