!Help Please! count some value between two dates
Final V1.0.xlsx
Dear All,
I need help of experts. I am making Gantt Chart(Project progress chart). One the second sheet I manage the Leaves of employee working on that project. See the attached file.
I want to count the number of leaves of an employee between two starting and ending dates of a project. I am not able to call countif or countifs function. Please help me to fill the J6 column automatically according the requirement I mentioned above:
Please see the attached file for reference
Last edited by nikkiddl; 05-28-2014 at 05:46 AM.
HI,
In need some more information, i want to know whether "name of person is unique & also the list of names in "LEAVE PLAN" & "Projects" follow the same sequence ?.
Punnam
Try..
In J6
=SUMPRODUCT(((INDEX('LEAVE PLAN'!$C$4:$DD$8,MATCH(D6,'LEAVE PLAN'!$A$4:$A$8,0),))="L")*('LEAVE PLAN'!$C$1:$DD$1>=E6)*('LEAVE PLAN'!$C$1:$DD$1<=G6))
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks a lot for your reply... Ploblem is solved now by Ace_XL.Originally Posted by Punnam
Thanks dear.... It's work as I want.
Actuly I want this at I6. But due to circuler dependency I am not able to impliment this on that cell. Is there any way to impliment this on I6 so I need not to copy J6 to I6 everytime.
Currently your 'End Date' (Col G) is dependent on Column I causing the circular reference. You need to ascertain the 'End Date' by some other mechanism to do away with the circular reference
Thanks a Lot.... I am Happy... best forum
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks