Numbers help: easy way to do this?

Discussion in 'Mac Apps and Mac App Store' started by JT3Jon, Mar 23, 2010.

  1. JT3Jon macrumors member

    Joined:
    Dec 20, 2008
    #1
    Hello,

    I'm an independent contractor and keep track of my hours worked & amount paid for the year in numbers, and thus far its working GREAT!

    However, I'm attempting to figure out how much my "pay per hour, per day" is, and need am wondering if there is an easier way to do this.

    My spreadsheet is setup like the following:
    Rows = Days worked
    Column F = Time worked
    Column G = Amount paid.

    So to figure out how much I made "per hour per day", I simply take Column G divided by Column F for each day. However, I'm currently manually entering this script into each row, and given that I worked over 200 days last year, its becoming a pain! (i.e. I manually enter in row 1 =SUM(G1)/(F1); row 2 =SUM(G2)/(F2), etc.

    Is there an easier way to do this? Is there a way to sequentially apply scripts, so instead of manually entering G2/F2, it will automatically apply the =Sum G / F's of that row?

    Thanks in advance for your help and reply!

    p.s. I'm on numbers 08
     
  2. renzach macrumors newbie

    Joined:
    Mar 23, 2010
    #2
    Hi there

    Define the sum for the first row, i.e., row1 =Sum(g1)/(f1). Now you will see a small circle on the right bottom side of that cell. Just drag the cell by pulling that circle. It should do the trick.

    HTH

    zach
     
  3. JT3Jon thread starter macrumors member

    Joined:
    Dec 20, 2008
  4. renzach macrumors newbie

    Joined:
    Mar 23, 2010
    #4
    Welcome. mate.
     

Share This Page