Nikky has attended:
No courses
Functions
I have a row with constant cell figures of
RE: 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