I have the following list 1-10:
1 RED 5
2 0
3 RED 5
4 GREEN 10
5 BLUE 15
6 YELLOW 20
7 0
8 BLUE 15
9 0
10 GREEN 10
I want to loop through and sum all the values
for "red", "blue", "yellow", "green" and paste them above the list. For
example, in cell A1 is RED, B1 is BLUE, C1 is YELLOW, etc. and in cell A2
would be 10 (the sum of both red values), B2 would be 30, C2 would be 20.
I can write the code for the loop but I don't know how to sum several values
programmatically and then paste that value in another cell.