This is what i'm trying to do:
=SUM(F2*L5)
=SUM(F3*L5)
=SUM(F4*L5)
...etc.
Is there a way to do this without manually typing in a new formula every row?
This is what i'm trying to do:
=SUM(F2*L5)
=SUM(F3*L5)
=SUM(F4*L5)
...etc.
Is there a way to do this without manually typing in a new formula every row?
Hi and welcome to the forum
Try this...
=SUM(F2*$L$5)
$ is used to absolute a cell reference, locking it so that when copied, it doesnt change.. it comes in 3 different "flavors...
$A$1 absolutes the entire cell reference, it will not chance when copied down or across
$A1 absolutes only the column, "A" will not change when copied across, but "1" WILL change when copied down
A$1 absolutes only the row, "1" will not change when copied down, but "A" will change when copied across
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks