Hey everyone! I’m working on a spreadsheet and I’m stuck. I’ve got a list of sales data and I want to add up the total for each unique item. Like if ‘Widget X’ shows up twice with 5 and 3 sales, I want it to show ‘Widget X - 8’ in the end.
I’m not great with formulas, so I’m hoping someone can help me figure out how to do this automatically. It would save me loads of time!
Here’s a quick example of what my data looks like:
hey ameliat. u can just cre8 a pivot table. select ur range, go to insert and then pivot table, and set item for row and sales for values. it sum up every item automatically. tried and works fine, trust me.
I’ve dealt with similar situations in my work, and while pivot tables are great, sometimes a more flexible solution is needed. For larger datasets, I’ve found SUMIF to be incredibly useful. Here’s how you can set it up:
In a new column, list your unique items. Then, in the adjacent column, use this formula:
=SUMIF(A:A,E2,B:B)
Where A:A is your Item column, E2 is your unique item cell, and B:B is your Sales column.
This method allows for easy updating and can be dragged down for all items. It’s also handy if you need to perform additional calculations or sorting later on. Just remember to adjust the column references if your data is structured differently.