Formula question

%3CLINGO-SUB%20id%3D%22lingo-sub-2059281%22%20slang%3D%22en-US%22%3EFormula%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2059281%22%20slang%3D%22en-US%22%3EWhat%20excel%20formula%20do%20I%20use%20for%20an%20excel%20template%20that%20I%20want%20to%20sum%20all%20the%20donations%20given%20by%20id%20%23.%20There%20about%202000%20line%20items%20of%20id%20%23s%20and%20related%20donation%20%24s.%20However%2C%20many%20of%20the%20id%20%23s%20repeat%20and%20I%20want%20to%20get%20a%20combined%20total%20of%20donations%20per%20id%20%23.%20Thx.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2059281%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2059509%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2059509%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928492%22%20target%3D%22_blank%22%3E%4021_Cyn%3C%2FA%3E%26nbsp%3BI'd%20recommend%20you%20to%20look%20into%20using%20a%20%3CSTRONG%3Epivot%20table%3C%2FSTRONG%3E.%20It%20can%20summarise%20such%20data%20instantly.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
What excel formula do I use for an excel template that I want to sum all the donations given by id #. There about 2000 line items of id #s and related donation $s. However, many of the id #s repeat and I want to get a combined total of donations per id #. Thx.
1 Reply

@21_Cyn I'd recommend you to look into using a pivot table. It can summarise such data instantly.