πŸ”₯ 0

BasicsCopy a formula down

Write a formula once, then copy it down the column. Excel moves the references along: =B2*C2 becomes =B3*C3 one row lower. Here the copies appear in light green while you type.

Work out the total for every item. Write the formula for the first row; it is copied down for you.

A
B
C
D
1
Item
Price
Qty
Total
2
Pen
1.5
10
3
Pad
4
3
4
Ink
12
2
5
Tape
2.5
4
6