You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Reply
17 replies

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

Group Rows into Categories gone in new Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.