I have a worksheet as you all know i've been asking a bunch of questions about.

as you can see in this picture:

http://img186.imageshack.us/img186/9...uestionxk0.jpg

i have 2 columns (actually more, but just for this example) and there classified in the right column as a,b, or c and on the left i have values for the individual properties within these building classes.

What i want to do is add up all of the properties in the a class, b class, and c class and put them in one small table on the right. I was thinking it would involve either or both of the IF THEN and VLOOKUP functions.

any help would be most appreciated!