Hello, I have a several dynamic ranges that are similar to:
and then on another sheet (same workbook) I have a data validation list with a list of the named ranges.
Im useing this formula:
and getting a #ref error. Please advise.
Code:
=Sheet2!$C$2:INDEX(Sheet2!$C:$C,MATCH(9.99E+307,Sheet2!$C:$C))
and then on another sheet (same workbook) I have a data validation list with a list of the named ranges.
Im useing this formula:
Code:
=SUM(INDIRECT(C2))