Linking and macros

[ciarzy_boy]

I'm going to do my best to describe what I'm trying to do, this URL: shows whats happening best I believe: http://lh5.ggpht.com/_IiHVAITrWcc/SnpSc_ID8kI/AAAAAAAAAXI/H3QdH1OaqK4/excel.JPG

So in Column A I have peoples names, B specific things they're ordering, C the amount of things they're ordering and then in G 2,3, 4 and 5 are the amounts of everything they're ordering. I've tried to go through some of the VBA stuff but I'm still a little confused. What I want to do is subtotal the amount of 1000, 1001's etc...

If it was c++ I'd be okay(I think) and write an algorithm that went something like this(in my hybrid c++ excel and matlab code):

for (c1:c200, c=1, c++){ //go through every row of column c
if cell=="1001"{
total=total + d(whatever value c is during the loop)
}
}

and then I'd have cell G2 equal this summed value.

Does this have to be done through VB and if so are there some handy online resources for this? If not can anyone help in anyway?

Thank you all,
Ciaran

 

[Mexcel]

The link to the picture is dead but try =SUMIF(...) in a worksheet. Excel help will explain how that works.