Numbers formula help

EmilyJ

macrumors newbie
Original poster
Dec 18, 2013
2
0
Hi, I'm having trouble creating a formula in Numbers and would appreciate any help.

I'm creating a spreadsheet to track employee annual leave, and most columns are set up correctly, but I can't work out how to create a column to track how many days have been taken so far.

In the attached screen-grab, I want column D to keep a sum total of the number of days taken by adding the entries so far from column C. I've filled in the first 4 entries using a formula for each cell but I want to be able to spread the 'rule' down the column so that other cells auto-update.

At this rate it'd be quicker for me to do it manually but I know I must be missing something really simple!:confused:

Thanks,
Emily
(I'm very familiar with Macs and computing generally, but unfamiliar with Numbers spreadsheets...)
 

Attachments

quickie14

macrumors newbie
Apr 20, 2012
8
0
Personally I would just use a formula that would look the previous bookable days taken cell + current No. of days (example D10+C11).
 

EmilyJ

macrumors newbie
Original poster
Dec 18, 2013
2
0
Fixed

Thanks quickie14, I'm embarrassed I didn't think of doing it that way!
All sorted. :)
 

quickie14

macrumors newbie
Apr 20, 2012
8
0
No problem EmilyJ, happens to us all.

I'm still a bit new to numbers, I grew up with Excel. What you was trying to do I have been doing for 8+ years, some of my spreadsheets are in a world of the own (so I'm told).
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.