Numbers formula question

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