the sum subtract each cell with a specific cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1776083%22%20slang%3D%22en-US%22%3Ethe%20sum%20subtract%20each%20cell%20with%20a%20specific%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1776083%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20get%20the%20total%20of%20subtracting%20each%20cell%20from%2018%20Sep%20till%2024%20Sep%20with%20the%20daily%20WH%26nbsp%3B%3C%2FP%3E%3CP%3Eex.%20%3D(12.16%20-11)%2B(12.17-11)%2B(16-11)%20and%20so%20on%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22590%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3EDaily%20WH%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2266%22%3E18-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2266%22%3E19-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2266%22%3E20-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2266%22%3E21-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2266%22%3E22-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2266%22%3E23-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2266%22%3E24-Sep-20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E11%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E12.16%3C%2FTD%3E%3CTD%3E12.17%3C%2FTD%3E%3CTD%3E16%3C%2FTD%3E%3CTD%3E15.45%3C%2FTD%3E%3CTD%3E16.49%3C%2FTD%3E%3CTD%3E17.01%3C%2FTD%3E%3CTD%3E16.55%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1776083%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1776173%22%20slang%3D%22en-US%22%3ERe%3A%20the%20sum%20subtract%20each%20cell%20with%20a%20specific%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1776173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765412%22%20target%3D%22_blank%22%3E%40Fayezsamea%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1776175%22%20slang%3D%22en-US%22%3ERe%3A%20the%20sum%20subtract%20each%20cell%20with%20a%20specific%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1776175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765412%22%20target%3D%22_blank%22%3E%40Fayezsamea%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESomething%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20612px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226361iEE361EA1B78E1435%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Edrag%20it%20to%20the%20right%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1776986%22%20slang%3D%22en-US%22%3ERe%3A%20the%20sum%20subtract%20each%20cell%20with%20a%20specific%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1776986%22%20slang%3D%22en-US%22%3E%3CP%3Ecan%20I%20add%20an%20if%20condition%20to%20calculate%20only%20if%20the%20value%20is%20above%26nbsp%3B%20%3CFONT%20color%3D%22%23FF0000%22%3EDaily%20WH%3C%2FFONT%3E%3C%2FP%3E%3CP%3Eand%20another%20one%20for%20if%20the%20value%20is%20less%20than%26nbsp%3B%20%3CFONT%20color%3D%22%23FF0000%22%3EDaily%20WH%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1780499%22%20slang%3D%22en-US%22%3ERe%3A%20the%20sum%20subtract%20each%20cell%20with%20a%20specific%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1780499%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40Ramiz_Assaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20for%20your%20answer%20it%20helped%20me%20a%20lot%3C%2FP%3E%3CP%3Esame%20formula%20I%20want%20to%20calculate%20on%20if%20the%20number%20is%20greater%20than%2011%2C%20and%20another%20formula%20only%20if%20the%20number%20is%20less%20than%209%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22590%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264px%22%20height%3D%2256px%22%3EDaily%20WH%3C%2FTD%3E%3CTD%20width%3D%2264px%22%20height%3D%2256px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E18-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E19-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E20-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E21-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E22-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2266.4px%22%20height%3D%2256px%22%3E23-Sep-20%3C%2FTD%3E%3CTD%20width%3D%2266.4px%22%20height%3D%2256px%22%3E24-Sep-20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2264px%22%20height%3D%2229px%22%3E11%3C%2FTD%3E%3CTD%20width%3D%2264px%22%20height%3D%2229px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2229px%22%3E12.16%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2229px%22%3E12.17%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2229px%22%3E10.1%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2229px%22%3E15.45%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2229px%22%3E16.49%3C%2FTD%3E%3CTD%20width%3D%2266.4px%22%20height%3D%2229px%22%3E9%3C%2FTD%3E%3CTD%20width%3D%2266.4px%22%20height%3D%2229px%22%3E16.55%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Elike%20the%20extra%20Hrs%20are%20(12.16-11)%2B(12.17-11)%2B(15.45-11)%20and%20so%20on%3C%2FP%3E%3CP%3Eand%20for%20the%20less%20Hrs%20ONLY%20(11-10.1)%2B(11-9)%20and%20so%20on%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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-2019-Sep-2020-Sep-2021-Sep-2022-Sep-2023-Sep-2024-Sep-20
11 12.1612.171615.4516.4917.0116.55
8 Replies
Highlighted

@Fayezsamea 

Like this?

Highlighted

@Fayezsamea 

Something like this

image.png

drag it to the right

Highlighted

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

@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-2019-Sep-2020-Sep-2021-Sep-2022-Sep-2023-Sep-2024-Sep-20
11 12.1612.1710.115.4516.49916.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

@Fayezsamea 

As variant

image.png

Highlighted

@Sergei Baklan 

 

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

Highlighted

@Fayezsamea 

 

Here it is done in once cell

similar to the logic I used before

Highlighted

@Fayezsamea 

Just for the collection one more variant

image.png