How to count a range of different names from a range of dates?
Sheet A has a week ending date column (always Sunday). Sheet A also has a column called Manpower where I am trying to write a formula. Looks like this,
Sheet B Has an install date and an Installers Name. Looks like this,
The formula I am trying to write would find all dates from Sheet B that fall within the week ending date of Sheet A and count the number of (different installers *8) *5.
Any help from the community would be very appreciated...
Help Article Resources
Check out the Formula Handbook template!