Forum Discussion

macg4867's avatar
macg4867
Copper Contributor
May 23, 2018

Aggregate by Two Columns Sum a Third

New to the community so hello.  I've searched and searched for a solution with no success. What I need to do is group rows of data by two separate columns and then sum the values in a third related c...
excel
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
May 23, 2018

Jeff,

 

the easy way: Insert a pivot table. "Upload Fund Code" and "Federal Year / Calendar Year" in row area and "Overpayment" in values area.

  • macg4867's avatar
    macg4867
    Copper Contributor
    May 29, 2018

    I prefer easy. I'll insert a pivot table. I was hoping that it could be done with a formula but I'm starting to think it's not possible or worth the effort. 

     

    Thanks for the response.

    Jeff

     

Resources