I am working with a data set of over 10,000 rows. Each of the rows contains a store number and each store number has monthly costs and total annual cost for its columns. In the data set, some of the store numbers are repeated more than once and contain different costs. I would like to sum the rows of the duplicate store numbers together and then make it into one row and delete the others. Does anyone know what kind of formula I could input for this? I have been trying all sorts of sumifs/if statements but cannot think of anything. Have been trying to solve this for the last two days so any help at all would be greatly appreciated!
Bookmarks