I have a project I am working on and I am stumped at the current time.
I am trying to get a total value to populate on sheet Labor in cells E6 THRU L6.
This value should be determined by the dates above it i.e. the total should be all values between these two dates. I also need to break it up by a work cell in this case it should only be looking for what is in A2 on the Labor sheet.
I have attached a sample of what I am working on and the formula I have been trying is this:
however this only gives me a #VALUE!
Any help would be great as I have been stuck for about a week on this.