• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

index function to count the position

ganeshm

Member
Hi friends,

I refer Supervisor in sheet 1 B10 and trying to count required supervisor as per the project start date and finish date. Kindly find attached the excel file and advice accordingly.

EX 1
Position : Supervisor
Check cell: $E$2 (Start Date) and $E$3 (Finish Date) in sheet 1, the result is 3
Result cell: $I$15 which is 3.

EX 2
Position : Supervisor
Check cell: $F$2 (Start Date) and $F$3 (Finish Date) in sheet 1, the result is 1
Result cell: $I$15 which is 4 (earlier this position had 3 and now 1 more added, so total 4).

Once the project is finished the result cell should get reduced according to the project finish date.

If requisition comes, it should increase as per the demand.

Thank you in advance

Regards,
ganeshm
 

Attachments

  • Copy of Project.xlsx
    638.9 KB · Views: 8
somthing is wrong.
>As per your post, "I refer Supervisor in sheet 1 "B10",
but in sheet1 "B10" is BUNDLE PULLER SUP. whereas "SUPERVISOR" in "B8".

>You required "Result cell: $I$15 which is 3" : In which sheet name? Kindly highlighted.
Also clarify logic of calculation.
 
Back
Top