Hello
I am trying to set up some formulas to help with reporting of leave balances for staff.
I will be downloading the pay run hours information into a worksheet, adding if the hours are to be used for calculating the accrual (accruable, not accruable). If the hours are accruable, I want to be able to sum the hours for each staff member to use for calculating the leave accrual.
I have tried several different combinations including sumif and vlookup, but just have not been able to get the formula in the correct format to work, so I am hoping that someone can help me out.
I have uploaded a sample excel workbook.
Hi Sheralee,
No workbook attached. Click on the Start Upload button after selecting the file.
Phil
File attached
And the Excel version????
I am currently using Office 365
I assumed you are wanting a formula for column I in the Staff List. See if the attached file works for you.
Hello Riny
Thank you very much, I had a look at the data and it looks like it is working perfectly.
I very much appreciate your help with this formula 🙂
Regards
Sheralee
Glad I could help!
