• 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.

Calculating the project manday details

Robotter

New Member
Hello Friends,

This is my first post here and I am glad to be in a place which is so much of a learning.


I have a very common requirement.


The problem:

In my organisation, multiple engineers work on multiple projects at different times. I would like to track the following things at the end of the month/a particular time frame.


1) The total days all engineers have worked on a particular project. (which of all the engineers have worked on the particular project and for how many days for the queried time line (from 1st of a month to say 30th of the month))


2) How many of the above mandays are billable/nonbillable?


I have captured the input data in the format shown in the xls file at http://rapidshare.com/files/426117410/To_Forum.xls


I tried to search within the forum but in vain.


Thanks for any help.
 

xld

Member
You need to explain that data in more detail, and the correlation between those two worksheets.
 

Hui

Excel Ninja
Staff member
Robotter

On Sheet2 B35:B38 put Proj 1 .. Proj 4

on C35: =COUNTIF(C$4:C$33,"="&$B35)

Copy C35 down and across to F38


Not sure about Sheet 4


Not sure about billable/non billable as you don't have sufficient fields to distinguish each for each engineer each day
 
Top