To find count of leave occasion
Hi Friends,
I have many employees data who takes leave continuously like 3 days. Then after some days again 1 day, then after few days continously 2 days. So the total occasion he took leave is 3. But number of leave days is 6. Here I want to get occasion of leave taken that is 3. So please help me to find that.
Excel sheet attached. I want to get that occasion count in each employee row. Please help me.
=SUMPRODUCT((B2:W2=1)*(C2:X2=""))
copied down.
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.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Sorry! It should be:
=SUMPRODUCT((B2:X2=1)*(C2:Y2=""))
Thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks