Forum Question: iWork Numbers: Subtracting for Entire Column

I have 3 columns of values. Column A & B I have entered values. Column C I want the formula to be C1=A1-B1, C2=A2-B2, and so on. BUT I don’t want to have to go down Column C and enter the formula for each cell. How do I make a subtraction formula that will calculate all of Column C for me?

Comments: 6 Responses to “iWork Numbers: Subtracting for Entire Column”

    1/20/11 @ 9:39 am

    Place the formula in the first row of column C. Select that cell and Copy. Then select the rest of the rows (C2 through C100 or whatever) and Paste.

    1/20/11 @ 9:47 am

    Thank you Gary! Is there a way to make a formula for specific column without having to copy & paste?

      1/20/11 @ 9:51 am

      There might be. But copying and pasting is quick and easy. I’m not sure it would save you much time.
      The problem might be that you may not want the formula applied to every single row in the column — there might be header or footer columns that you’d want to exclude. So this method give you more control.

    1/20/11 @ 10:05 am

    Great thanks again!

    1/5/13 @ 3:38 am

    I have a list of numbers in Column H. I want to subtract each following cell(ie H3, H4, H5 etc) from H2 and display that number in another column (J). Is there a way to do this quickly, rather than rewrite the formula each time? When I use copy (using small circle in the bottom right of cell) it shifts the formula so that it’s subtracting from the cell above. I want each cell to always be subtracted from the same cell.

      1/5/13 @ 9:24 am

      Sounds like you need to change one of the elements of the formula to an absolute value instead of a relative one. Click on that value in the formula at the top and you’ll see. Or look up “absolute” in the Help.

Comments Closed.