Forum Discussion
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
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
Like this?
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
