Which is an excel formula I can use to combine rows together based on the same category and same month with the updated sum of the two numbers?

CodePudding user response：

Formula-based alternative for O365:

=LET(ζ,SORT(UNIQUE(A2:B25),{1,2}),CHOOSE({1,1,2},ζ,SUMIFS(C2:C25,A2:A25,INDEX(ζ,,1),B2:B25,INDEX(ζ,,2))))

CodePudding user response：

I have created a simple pivot table, based on entries, similar like yours. This is what it looks like:

(The "Months" is added by Excel itself)