Functions

Hi Nikky,

In new column E, make the cell:
=($A$1*A2)+($B$1*B2)+($C$1*C2)+($D$1*D2)

Then use 'fill down' to copy the formula down to the other rows in the E column.

The dollar signs ($) before the letter and number cell reference indicates the formula should keep the same cell reference each time the formula is copied to another cell. It's called absolute cell referencing.

See also the attached spreadsheet in Excel 2003 format.

Regards, Rich