Posts

Showing posts from October 31, 2009

Excel Sum total amount if same data

Excel Summarizr items if they have the same name, how many is the item(s), sum the total amount of the items. Example Service Amount Item10 255 Item25 357 Item12 227 Item10 422.5 Item25 567 Item10 422.5 Item14 314.5 Item25 567 Item14 314.5 Item6 510 Item27 195.5 Item10 382.5 Item25 527 Item21 193 Item12 227 So here you have different items and prices How to get them summed in excel? ROW A is the items ROW B is the prices ROW C is the item name name (list all items if you have 100 items type it here) ROW D is how many is that item ROW E is how much is the total price of that specific item ROW D CODE =SUMPRODUCT(--(A3:A5211=C3)) ROW E CODE =SUMIFS(B3:B5211,A3:A5211,C3) Actual Excel Document with the computation here