Numbers post last value from a column

Discussion in 'Mac Apps and Mac App Store' started by AppleDApp, Aug 2, 2015.

  1. AppleDApp, Aug 2, 2015
    Last edited: Aug 2, 2015

    AppleDApp macrumors 68020

    AppleDApp

    Joined:
    Jun 21, 2011
    #1
    I am trying to create a graph that can be easily updated once a month. I want the Total row to get the last value entered from each column.

    In this case column A total should read 9. If in September the value is 12 I want Total for column a to reflect that.

    The value in the total row will be used for a pie and line chart.

    What would be the appropriate formula to automate this as much as possible?

    EDIT I called AppleCare and they are telling me there is no such formula.

    Apple numbers function link
     

    Attached Files:

  2. ricosuave, Aug 3, 2015
    Last edited: Aug 3, 2015

    ricosuave macrumors 6502

    ricosuave

    Joined:
    Mar 27, 2007
    Location:
    In front of my mac
    #2
  3. AppleDApp thread starter macrumors 68020

    AppleDApp

    Joined:
    Jun 21, 2011
    #3
    That looks great I will give it a try when I get home. Is there a way of running the formula without having the column next to the left of the month column?
     
  4. ricosuave macrumors 6502

    ricosuave

    Joined:
    Mar 27, 2007
    Location:
    In front of my mac
    #4
    The lookup reference needs the largest number on a column. You could hide the first column. The second sheet has it hidden.
     

Share This Page