Tag Info

Hot answers tagged


Prepend the column letter and/or row number that you don't want to change with $. Let me illustrate: Let's say in cell B2 I have this formula =B1*A1 If I copy that to C2, what is pasted in C2 is =C1*B1 But that's not what I want. I always want to multiply against A1. If, instead, B2 was =B1*$A$1 Then when I copied to C2 I'd get =C1*$A$1 If I ...


If you have multiple sums in the formula, you need multiple SUM commands, one for each sum. That is, =F15*20+SUM(F16:F20)*25+SUM(F21:F23)*30 Have to add things up before multiplying them all by a common factor.

Only top voted, non community-wiki answers of a minimum length are eligible