Numbers formula question

Discussion in 'Mac Apps and Mac App Store' started by bowens, Mar 20, 2008.

  1. bowens macrumors 6502a


    Jun 19, 2006
    Trenton, FL
    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?
  2. mackindergarten macrumors 6502

    Feb 21, 2008

    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.


Share This Page