Summing totals for corresponding random generated numbers

[hanzsolo]

I'm generating a random integer in column A (product) between 1 and 20 and another random integer in column B (quantity) between 1 and 100.

I want to record the total quantity for each product in column C. How do I do this?

 

[Joe4]

So, do you just want to add the numbers in columns A and B and report the total in column C for each row?

If so, then it should be as simple as a formula like this is C1:
=A1 + B1

 

[hanzsolo]

No, I have a list of 30 rows of randomly generated Products in column A. I want to automatically total each products randomly generated quantity (col b) in column C.

A B C D
1 10 1 20
2 50 2 50
1 10 3 0
5 20 4 0
7 50 5 20

C2 is product 1
D2 is the total number of product 1 (B2+B4) =10+10=20

I would like to automatically populate the fields instead of manually adding the numbers

 

[Joe4]

Use SUMIF. Place this formula in D2 and copy down for all rows:
=SUMIF(A$2:A$6,C2,B$2:B$6)

Obviously, you will need to adjust your formula to account for the total number of rows you have.