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