Oh boy, This is awkward to describe. What I am looking for is a formula. I have two active colums and a third to add the sum. One colum is full of figures($$) and the column next to it is for the category that the numbers from the first column coresponds to. Next, on the third column, I have three boxes that will add the totals of the 3 different categories that the second column differentiates. You may ask, "Why don't you just start another worksheet and do it that way?" Well on the same worksheet I have other figures that correspond to the total information required, so I would like to be able to have it all on one worksheet with the smallest space (width) available. So I am hoping that there is a way. Appreciate any suggestions you may have.

ok, here is an example of my attempt to figure this formula IF(b3:b149=12)then,Add(a3:a149) This obviously does not work, but hopefully I can explain this as to what I am tring to do. Ok. So column a is the figures($$). b is the column that catergorizes these figures(in my case they are divided into 3 categories. So I will name these categories 1,2,3). In column c, I need the category numbers and add the coresponding figures from the a column of all the category 1 (2&3's in separte boxes in column c)into one TOTAL box in column c. Hope this helps.

OOPS instead of 12, the number in this example would be 1,2 or 3 to represent the 3 different categories that exists in column a(figures in $'s).

See the Help file on SUMIF =SUMIF(B3:B149,1,A3:A149) =SUMIF(B3:B149,2,A3:A149) =SUMIF(B3:B149,3,A3:A149)

DUDE! THANK YOU! That seems to do the trick alright. Exactly what I wanted to do. Again thank you for your time.