Thread: Specific locked cell formula, autofill problem

Not sure how to name or really describe what I want to achieve so here goes

Formula : =SUM(G2*G5+H2*H5)+L5+M5

Where G2 and H2 are the price, G5 and H5 are quantity.


Problem when dragged at the corner of the cell which copies the content of the first cell :
=SUM(G3*G6+H3*H6)+L6+M6
=SUM(G4*G7+H4*H7)+L7+M7
=SUM(G5*G8+H5*H8)+L8+M8
and so on..


What I need to achieve is :
=SUM(G2*G6+H2*H6)+L6+M6
=SUM(G2*G7+H2*H7)+L7+M7
=SUM(G2*G8+H2*H8)+L8+M8

Where both G2 and H2 remain the same(locked) and others will continue to add itself. I have over 300 rows to fill in the formula of what I need to achieve. I find it really tedious of having to correct the errors made when I use the autofill function, so is there any convenient way that I could achieve the result I wanted? I hope this makes sense to anyone of you.

Thanks in advance!

Try:

=SUM($G$2*$G5+$H$2*$H5)+$L5+$M5

Although the Sum function here is redundant in the context you have written...

Multiplication gets done first, then addition.

You should use either:

=$G$2*$G5+$H$2*$H5+$L5+$M5

or

=SUM($G$2*$G5,$H$2*$H5,$L5,$M5)