The first solution works using B2 and C2 cell formulas.
I want to copy this down through 60 sets of values. Copy/paste doesn't change the cell references. Is there an easier way to do this than changing each formula and recopying for each set of values?

TIA