Hi there, I'm very new to excel and i'm trying to solve this problem as stated in the title. I have a list of design titles, and I want to get the sum of total sales for each design and have it listed on the same row. I could do each one individually, but I have 800+ entries so that would take a while. Is there a way sumif can check a design name in a column (Under design name column A in photo 2), check another column to see if the name matches (Under column B in photo 1), add the sales if the names matches (Numbers listed in column AD in photo 1) and then go to the row below it to do the same thing for the next design name? For example, starts off on "#1 dad", does that process, puts the sum in b2, goes to "#warmwishes" and repeats. Any help would be greatly appreciated, thanks in advance!
Bookmarks