Got a question for you spreadsheet gurus. I'm no good at this stuff...
I have 2 columns. Column A is a range of numbers. Column B is a specific word relating to the number of the same row of Column A.
I want to make an equation to add all the numbers in Column A if the word in Column B equals ... whatever I want it to be. Here's an example of the data:
A B
3 red
6 green
2 red
7 red
2 green
4 blue
And here is the outcome I want... Add all red = 12. Add all green = 8. Add all blue = 4
I have 2 columns. Column A is a range of numbers. Column B is a specific word relating to the number of the same row of Column A.
I want to make an equation to add all the numbers in Column A if the word in Column B equals ... whatever I want it to be. Here's an example of the data:
A B
3 red
6 green
2 red
7 red
2 green
4 blue
And here is the outcome I want... Add all red = 12. Add all green = 8. Add all blue = 4