Hi All,
Is there a formula that I can use the would accommodate the following? Example: I need it to sum all named ranges called "AAA_(unique number)" and then dividing that by all named ranges called "BBB_(unique number)". So the (unique number) at the end of the name is variable, and these named ranges can/will be created after this formula is in place so I cant hard code the complete name in the formula, how would a write the formula to sum all the ranges that "match" a certain amount of the name (for this example, AAA and BBB)?
Is there a formula that I can use the would accommodate the following? Example: I need it to sum all named ranges called "AAA_(unique number)" and then dividing that by all named ranges called "BBB_(unique number)". So the (unique number) at the end of the name is variable, and these named ranges can/will be created after this formula is in place so I cant hard code the complete name in the formula, how would a write the formula to sum all the ranges that "match" a certain amount of the name (for this example, AAA and BBB)?