Using names in named formula

P

Peter Atherotn

Nick

Yes formulas can use range names. It sounds that you have
given names to the labels, i.e. the wrong cell.

Have a look at the cell references for each name and make
sure that they are the same as in your formula.

Regards
Peter
 
Top