Loop to Sym and Average values by System

Hello,

I have two columns: System and Value, and I want to sum and average the Value for each system.
So for example, system X should be Sum=400 and Average=200, System Y should be Sum=600 and Average=300, those values should be put into cells starting at column H.
Actually the difficult part for me in this case is the logic. I was able to get the first system value and move to the next column, but not able to continue...
Can someone help me please?
I have attached the spreadsheet....

There is some initial code I wrote in the spreadsheet

Pl see attached file.

I appreciate much your help, but I really need this in Excel VBA. I am stuck on the logic to use... I am able to calculate the average and SUM ofr the first system, when I go to seconds system I am unable to set counter to zero, I do not see yet a way to make it work. This is what I have so far(this code is new and is NOT in the attached spreadsheet), so in case you check this thread, please use the below code as reference:

Please Login or Register  to view this content.

Now I would like to Average the values by System, but with data not in sequence like this:

System Value
X 400
Y 328
Z 222
X 427
Y 339
Z 212
X 409
Y 347
Z 205



So with the above data I would like to have something like this resullt:
For System X: Average of 1236 and Sum of 512
For System Y: Average of 1014 and Sum of 338
And so forth... so the only difference now is that the data of system is not in sequence

Any suggestions on how to do that?