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
- 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
- If Cells Have a value, copy and paste into new worksheet
- to loop or not to loop
- how to ingreement the loop value automaticaly still last regards
- Populate array value using For Next loop
- program using while loop and for loop
- sum of amount deliverd group
- Calculate Total Sum
- Sum colunm total in repeater
- count the sum of a column
- SUM content of rows
- custom Sum function?
- Summing a range of variable size
- VBA code to sum
- sum in columns
- Summing on varying number of rows in Excel using VBA
- Summing a range
- getting the sum of the last 20 cells
- Conditional Summing