# 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?

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

Joined:
Dec 20, 2008
4. ### renzach macrumors newbie

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