I have a product line consisting of 4 resources (A,B,C,D) and the hours per day (averaged) they do. These columns have varying hours depending on dates. I have an on the spot date where i want to know how many hours of A,B,C,D (seperately) will be used per day. I have over 1000 "on the spot" dates i need to check. I've been trying to use SUMIFS but had no luck.


Start_Date -- Finish_Date --- A -- B -- C-- D
01/01/2011 -- 01/03/2011 -- 10-- 5 -- 4 -- 3
10/02/2011 -- 10/05/2011 -- 7 -- 6 -- 2 -- 1
15/02/2011 -- 10/05/2011 -- 8 -- 7 -- 2 -- 2