Hi,
I have 4 sheets (Jan, Feb, March and consolidate). Need to calculate the salary in consolidate sheet.
In march sheet two emp name is missing. How to calculate this?
Thanks
Hi,
I have 4 sheets (Jan, Feb, March and consolidate). Need to calculate the salary in consolidate sheet.
In march sheet two emp name is missing. How to calculate this?
Thanks
Hi. One way of doing this utilises SUMPRODUCT, INDIRECT and a list of your sheets.. See the attached file.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks