Numbers formula question

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

  1. bowens macrumors 6502a

    bowens

    Joined:
    Jun 19, 2006
    Location:
    Trenton, FL
    #1
    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

    Joined:
    Feb 21, 2008
    #2
    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
     

Share This Page