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
- to loop or not to loop
- program using while loop and for loop
- how to ingreement the loop value automaticaly still last regards
- Populate array value using For Next loop
- Conditional Summing
- getting the sum of the last 20 cells
- sum formula
- how to sum the even numbers only
- Summing on varying number of rows in Excel using VBA
- Summing a range
- VBA code to sum
- sum in columns
- count the sum of a column
- SUM content of rows
- custom Sum function?
- Summing a range of variable size
- Sum colunm total in repeater