Sum of a specific item into another column

[chamblee]

Okay here is what I am trying to acomplish and not sure if I am approaching it the right way.

Attached is a sample file


I want the total columns to look something like this but not sure how to do it:

Please Login or Register  to view this content.

I know that the formula I have is wrong but not sure how else to do it, not really sure on how to use the vlookup function so I am not sure it that is a way to acomplish this or not.

And I know that this data is easy to just look and see what my answer is but I am doing this with
+/-1000 rows of data so I really need some way to automate this.

Thanks in advance for any help you guys can offer me.

[ConneXionLost]

In your sample, try:

Please Login or Register  to view this content.

Cheers,

[chamblee]

Thank you thank thank

You turned code that looked like that

Please Login or Register  to view this content.

in to one simple line