a = shift (range name)
b = 10/24/10 (cell reference)
c = 10/30/10 (cell raference)
need to count shift with occurance in Date Range 1 if >=b or <=c or Date Range 2 =if >=b or <=c
Same date within to seperate range names.
Cannot seem to get this to work using SUMPRODUCT or SUM array. Assuming it is a syntax problem, but not sure.
Have been struggling off and on for days. Please help!