Manpower Loading Schedule

I am trying to create a Project(schedule) that has a manpower loading functions. I am almost there but I am stuck with trying to figure out how to see how many crew members I have on a certain days by suming them up. 

For example I would like to have a list of dates and then show how many crew members working on those dates. The examples should show 

4/29 = 15

4/30 = 15

5/1 = 50

5/2 = 50

5/3 = 35





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!