Notifications
Clear all
Topic starter
Hello. I need help to create formula for my excel.
Based on my excel file, the B2:B9 is the name of Company. The C2:C8 is the days of ‘off day’ that approved by HQ for the company as they apply.
On D2:D9 is where I want the formula to be. The value that I want is like the values on D13:D20.
I have tried several formula using COUNTIF, SUMIF, SUMIFS but still failed to get the values to be like on the D13:D20. Please help me.
Posted : 24/01/2020 10:23 am
The file attached appears not to be valid (zero bytes)
Can you try again
Purfleet
Posted : 24/01/2020 12:58 pm
