Hi - I have 2 columns with 200 rows. Column A in cells numbers - column B in cells text being categories
I require a formula to look at all cells and add up for each category
There’s about 15 categories in the cells with repeats
So example
A. B
1. 50. Red
2. 20. Green
3. 30. Red.
Result I need. Red = 80
Green = 20
I require a formula to look at all cells and add up for each category
There’s about 15 categories in the cells with repeats
So example
A. B
1. 50. Red
2. 20. Green
3. 30. Red.
Result I need. Red = 80
Green = 20