Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Loop, sum values and paste

  Asked By: Qadriyah    Date: Jan 19    Category: MS Office    Views: 816
  

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.

Share: 

 

No Answers Found. Be the First, To Post Answer.

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




Tagged: