Excel - Applying a formula for a range of cells

December 2016


I am trying to use a input cell in Excel:
  • In my Excel sheet I have data on A1,A2,A3,A4,A5 containing the amount of ml ink being used.
  • In cell B1 I have the input of Price per ml that I want the user to put in.
  • In C1 I have the formula of "=ROUNDDOWN(SUM(A1*B1),2)"
  • Now if I drag C1 down to C5 I want in my formula A1 to count from A1 to A5 but I don't want B1 to count but be constant.
  • My problem is when I drag down from C1 to C5 that in my formula B1 also counts from B1 to B5 .
  • How can I have B1 as input and remain constant in the formula


  • You have to put a $ between the B and 1 to fix the cell thus your formula become :



Thanks to aquarelle for this tip on the forum.

Related :

This document entitled « Excel - Applying a formula for a range of cells » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.