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