diogodasilva

Q: Group Rows into Categories gone in new Numbers

Can't believe Apple ditched Group Rows into Categories just to make it compatible across web and iOS?

Am I going crazy or what?

 

This is how it used to be: http://support.apple.com/kb/VI139

MacBook Pro, Mac OS X (10.7.4)

Posted on Oct 23, 2013 5:39 AM

Close

Q: Group Rows into Categories gone in new Numbers

  • All replies
  • Helpful answers

Previous Page 2
  • by flashkube2,

    flashkube2 flashkube2 Jul 11, 2016 12:37 PM in response to SGIII
    Level 1 (11 points)
    Mac OS X
    Jul 11, 2016 12:37 PM in response to SGIII

    I'm having trouble visualizing what is happening here. How does the second parameter in the sumif become the first column in the new table?  What points it there?

     

    What does the third parameter (A2 Name) do since it never shows up in the new table?  Why is it even in the formula at all?

     

    I've tried figuring out what the fifth parameter does from the help file but cannot see what cell B1 has to do with anything at all in the new table or the old one.  Why is it even there?

     

    Is the first parameter in the sumifs always the one that is getting summarized?

  • by Barry,

    Barry Barry Jul 11, 2016 1:07 PM in response to flashkube2
    Level 7 (32,271 points)
    Jul 11, 2016 1:07 PM in response to flashkube2

    I'm having trouble visualizing what is happening here. How does the second parameter in the sumif become the first column in the new table?  What points it there?

     

    Your post is two years (and a full page) away from the post you appear to be responding to. You have posted almost exactly the same question (to whch I have responded) in another old thread. Have you read my response there? Do you have further questions after that response? Please post them there, rather than in this separate thread.

     

    What does the third parameter (A2 Name) do since it never shows up in the new table?  Why is it even in the formula at all?

     

    It names the cell in row 2 of column A of the table containing the formula. For the reason it is there, read my response in the thread containing your earlier question.

     

    I've tried figuring out what the fifth parameter does from the help file but cannot see what cell B1 has to do with anything at all in the new table or the old one.  Why is it even there?

     

    See response to previous paragraph.

     

    Is the first parameter in the sumifs always the one that is getting summarized?

     

    Answered in my response to your previous post of this question, which can be read here.

     

    Regards,

    Barry

Previous Page 2