Forum Discussion
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...
Jeff,
the easy way: Insert a pivot table. "Upload Fund Code" and "Federal Year / Calendar Year" in row area and "Overpayment" in values area.
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