D
Duane
I have a named range. The range consits of about 8 rows, and spans across
about 30 columns (dates). I want to sum one of the rows in the range if it
falls between certain dates. The easy version would be:
=SUMPRODUCT((Sheet2!D1:AP1>=Sheet1!A2)*(Sheet2!D1:AP1<=Sheet1!D2)*(Sheet2!D28:AP28))
Where sheet1 A2 is a date, Sheet 1 D2 is a date, and Sheet 2 D28:AP28 is the
row of numbers I want to sum. the above formula works, but i want the
"Sheet2!D28:AP28" to be referred to as a line in my named range. The name of
the range is Arrow, and the line is FeedAmt. That way, I can use the formula
in several other cases using different range names.
Can this be done?
Thanks
about 30 columns (dates). I want to sum one of the rows in the range if it
falls between certain dates. The easy version would be:
=SUMPRODUCT((Sheet2!D1:AP1>=Sheet1!A2)*(Sheet2!D1:AP1<=Sheet1!D2)*(Sheet2!D28:AP28))
Where sheet1 A2 is a date, Sheet 1 D2 is a date, and Sheet 2 D28:AP28 is the
row of numbers I want to sum. the above formula works, but i want the
"Sheet2!D28:AP28" to be referred to as a line in my named range. The name of
the range is Arrow, and the line is FeedAmt. That way, I can use the formula
in several other cases using different range names.
Can this be done?
Thanks