A calculation works in one row but produces unexpected results after copying. One possible reason is that its cell references moved with it.
Watch one reference change
In a practice workbook, put quantities in A2 and A3 and one unit price in B1. A formula =A2*B1 uses relative references. Copying it one row down changes the references to A3 and B2. That may be correct for one design and wrong for another.
Hold the intended cell steady
If both rows should use the price in B1, =A2*$B$1 keeps that reference fixed when copied. Microsoft’s reference guide also explains mixed references, which fix only a row or column.
Check the formula itself in the first few copied rows, not just whether the displayed results look plausible. A blank or convenient value can hide a mistaken reference. Use a small, clearly labelled practice sheet before applying the idea to a larger workbook. The goal is to decide which inputs should move and which should remain attached to the same location.

