Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

bowens

macrumors 6502a
Original poster
Jun 19, 2006
828
137
Florida
I've got a numbers file for work that keeps track of all my sales. What I would like to do is have 5 sheets in a file. 1 for year to date totals and 1 for each quarter of the year. I want to enter the data into the year to date sheet and have it automatically update the appropriate quarterly sheet. I can't quite figure out how to do this. Also, I would like to do bar graphs that update when I enter new data in to show how I'm doing each quarter. Can anybody help me with this?
 
Hi,

sounds like you are on the look out for the SUMIF function.
I just played around with Numbers a bit, and I think I have what you need. Just drop me an IM with your email address, so I can mail it to you.

/Rupert
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.