Hi All,
I have a spread sheet that has the leave entitlement for our staff and their staff number. Some staff have multiple roles, meaning they have more than one leave entitlement. I need a formula that will add up staff entitlement from all their roles.
Please see the attached spread sheet, i have made an example of what i need to calculate.
Thank you in advance for any help you can provide.
Regards,
Luke.
can it be a pivot table?...because your data really lends itself to a PT....and updating the PT with new data is real easy....I have attached a file with the PT...
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks