Revision history [back]

The normal way is to use 4 cells for the amount, for example, A1 through A4. Then calculate the result in B1 (the final result) based on A1.

Use absolute referencing in B1 for all cells except A1. For example, if tools are always listed in cell G8, then reference it as $G$8.

Then drag to fill the formula down from B1 to B4.

The normal way is to use enter the amounts in 4 cells for the amount, different cells, for example, A1 through A4. Then calculate the result in B1 (the final result) based on A1.

Use absolute referencing in B1 for all cells except A1. For example, if tools are always listed in cell G8, then reference it as $G$8.

Then drag to fill the formula down from B1 to B4.

The normal way is to enter the amounts in 4 different cells, for example, A1 through A4. Then calculate the final result in B1 (the final result) based on A1.

Use absolute referencing in B1 for all cells except A1. For example, if tools are always listed in cell G8, then reference it as $G$8.

Then drag to fill the formula down from B1 to B4.