Excel 2003 Date Range with Range Names

January 2, 2011 at 12:11:58
Specs: Windows XP
Excel 2003

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!

See More: Excel 2003 Date Range with Range Names

Report •

January 2, 2011 at 14:39:12
Please review the How To referenced in my signature line and then post an example of your data.

Include some input data and the expected output based on that data.

With a better understanding of how your data is laid out we should be able to offer a solution.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question