Hi, I need a formula or macro to sum of hours on basis of matching date range and unique number. I have tried lookup formula but its not sum up the value. Attached file for with input and output reference, please help.