Formula question

Copper Contributor
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.