Excel - Applying a formula for a range of cells

Ask a question


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.
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team