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...
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
