I have attached the file I am working with.
The basic of what I need to do is take the data from Sheet2 and have it total on Sheet1.
Where it get's complex however is that I need that data to be pulled only when certain criteria are met.
So let me try and explain:
You will notice RAW data on Sheet 2, which includes a Date, Position, Block, Live Sim, Non-Pos.
On Sheet1 I need to pull the RAW data from Sheet2 and calculate it in the appropriate blocks after meeting the correct criteria.
So cell B9 on Sheet1 would need to contain the total LIVE hours from Sheet2 within the date range of 27 May-29 May and I would like for it to determine that by 2 criterias (Date, Block) When those three criterias from Sheet2 match it should total it there.
Then cell D9 would operate the same way, but would total the entire LIVE hours from the LIVE column of Sheet2.
Then B12 would be the total of B9:11 and D12 would be the total of D9:11.
The times need to stay in an hour+minute format such as 1+45 or 1:45 for 1 hour 45 minutes.
Any help would be greatly appreciated.
Bookmarks