Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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.

Didn't find what you were looking for?
Find more on Loop, sum values and paste
Or get search suggestion and latest updates.

Related Topics:

- Looped VBA to paste special values
- Looping thru values to match w/ other values
- Sum values entered into text boxes
- If Cells Have a value, copy and paste into new worksheet
- Easier method to capture & paste calculated value?
- Copying and Pasting Values From One Column To Multiple Columns Using
- Copy worsksheets and paste values only into new worksheet
- Copy numeric value rows and paste to new sheet
- how to ingreement the loop value automaticaly still last regards
- Populate array value using For Next loop
- to loop or not to loop
- program using while loop and for loop
- sum and difference of 2 bcd numbers
- Compute the sum of both positive and negative elements of an array
- Getting the sum and percentage in Excel coulmn
- sum and Multiply number and print in decimal
- sum of series of natural numbers
- sum cells with conditional formatting color
- Data Sum rows not hidded
- Summing on varying number of rows in Excel using VBA
- Summing a range
- VBA code to sum
- sum in columns
- Conditional Summing
- getting the sum of the last 20 cells