LCohen

Q: pages.app 6.0 formula glitch

For years I have been using a pages.app document to do a spreadsheat for my business.  Column A is a client's name, column b has the amount of the transaction, column c adds the number from column b to all the previous transactions and gives me a total for the month.  Each row will have a different number for column as numbers get added to sequential rows in column b. 

 

Now with pages.app 6.0 the number in column is added but not continued to the next row.  Anyone have an idea as to how I can fix this?

Mac Pro, Mac OS X (10.6.3)

Posted on Sep 26, 2016 1:18 PM

Close

Q: pages.app 6.0 formula glitch

  • All replies
  • Helpful answers

  • by VikingOSX,

    VikingOSX VikingOSX Sep 26, 2016 3:09 PM in response to LCohen
    Level 7 (21,123 points)
    Mac OS X
    Sep 26, 2016 3:09 PM in response to LCohen

    Not without looking at your table and formulas so we can further test in Pages v6.

  • by LCohen,

    LCohen LCohen Sep 26, 2016 4:48 PM in response to VikingOSX
    Level 1 (5 points)
    Mac OS X
    Sep 26, 2016 4:48 PM in response to VikingOSX

    Here's what should happen.  When client 2 is added with $500, column G goes to $1500, and etc.

    Screen Shot 2016-09-26 at 7.43.44 PM.png

     

     

    Here's what is happening with version 6.0.Screen Shot 2016-09-26 at 7.45.15 PM.png

    Column G isn't getting filled in on line 5 but on row 4 the new total is summed up.

     

    Here's is the equation used in column g

     

    Screen Shot 2016-09-26 at 7.47.01 PM.png

  • by VikingOSX,

    VikingOSX VikingOSX Sep 26, 2016 5:39 PM in response to LCohen
    Level 7 (21,123 points)
    Mac OS X
    Sep 26, 2016 5:39 PM in response to LCohen

    If I am understanding the total progression, then the following formulas populate correctly:

    Screen Shot 2016-09-26 at 8.37.18 PM.png

     

    G2

    Screen Shot 2016-09-26 at 8.30.10 PM.png

    G3

    Screen Shot 2016-09-26 at 8.30.36 PM.png

    G4

    Screen Shot 2016-09-26 at 8.31.01 PM.png

    G5

    Screen Shot 2016-09-26 at 8.31.37 PM.png

     

    What I see from your example is that cell G4 is set to sum(F2:F5), and I believe that formulas for G4 and G5 should be those above.

  • by LCohen,

    LCohen LCohen Sep 26, 2016 5:45 PM in response to VikingOSX
    Level 1 (5 points)
    Mac OS X
    Sep 26, 2016 5:45 PM in response to VikingOSX

    I appreciate the help.  I don't understand why the new version is macossierra has glitched things up.  What do I need to change about the formula?

  • by VikingOSX,

    VikingOSX VikingOSX Sep 26, 2016 6:11 PM in response to LCohen
    Level 7 (21,123 points)
    Mac OS X
    Sep 26, 2016 6:11 PM in response to LCohen

    Based on your screen shot showing the formula for cell G4, you were summing F2:F5, not F2:F4 — if I am understanding those Totals. Use my formulas for their respective G column cell and see if that clears up the Totals column.

  • by LCohen,

    LCohen LCohen Sep 27, 2016 9:10 AM in response to VikingOSX
    Level 1 (5 points)
    Mac OS X
    Sep 27, 2016 9:10 AM in response to VikingOSX

    This problem doesn't make sense.  I haven't updated my MacBook to MacOS Sierra yet and my template works just fine.  Now under the new OS and version 6.0 it doesn't work.  Why do I need I need to change the formulas when th

  • by LCohen,

    LCohen LCohen Sep 27, 2016 9:11 AM in response to LCohen
    Level 1 (5 points)
    Mac OS X
    Sep 27, 2016 9:11 AM in response to LCohen

    Why do I need to change the formulas when the template I have works just fine with the previous version of pages in El Capitan?

  • by VikingOSX,

    VikingOSX VikingOSX Sep 27, 2016 5:10 PM in response to LCohen
    Level 7 (21,123 points)
    Mac OS X
    Sep 27, 2016 5:10 PM in response to LCohen

    Well, when I am signed in, I cannot see your last two posts in either Safari or Firefox.

     

    You had selected cell G4 which would reflect Client 3 activity, and yet your formula was summing all four clients (f2:f5) to put 4400 in cell G4, instead of which I surmise it should be the summation of cells F2:F4 which would put 3500 in G4, as you have shown earlier.

     

    That's why you should change your formula, it isn't that Pages 6 has whacked your formula, but the formula itself for cell G4 is also including Client 4 financials, which is wrong for your pattern of Total values for each client.