 Highlighted

# the sum subtract each cell with a specific cell

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
8 Replies
Highlighted

Like this?

Highlighted

# Re: the sum subtract each cell with a specific cell

Something like this drag it to the right

Highlighted

# Re: the sum subtract each cell with a specific cell

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

Highlighted

# Re: the sum subtract each cell with a specific cell

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

Highlighted

# Re: the sum subtract each cell with a specific cell

As variant Highlighted

# Re: the sum subtract each cell with a specific cell

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

Highlighted

# Re: the sum subtract each cell with a specific cell

Here it is done in once cell

similar to the logic I used before

Highlighted

# Re: the sum subtract each cell with a specific cell

Just for the collection one more variant 